The Fastest way to go to the last cell in a worksheet in Excel - as well, I show you how to reset the location of the last cell after you delete data from the worksheet, which doesn't automatically update the location of the last cell.
List of Excel Keyboard Shortcuts: www.teachexcel.com/shortcuts/...
Excel Quickie 63: • CLEAN() Function in Ex...
Excel Quickie Playlist: • Excel Quickies
This tutorial shows you a helpful keyboard shortcut that will save you a lot of time when working in large spreadsheets. Once you get comfortable with keyboard shortcuts in Excel, you will hardly ever go back to using your mouse to get around and do things.
This is also a great technique to use to find any stray cells with data far off the screen.
You will also learn how to reset the location of the last cell so that you don't end up on blanks cells when you delete data from the worksheet and then use the shortcut to go to the last cell again, but, instead go to now blank cells which no longer have any data - this is an annoying issue that is easy to solve, thankfully.
Enjoy this Excel Quickie!
TeachExcel.com
#excel #tutorial #excelquickie
Негізгі бет Excel Shortcut - Go To the Last Cell in the Worksheet (Also Reset It) - Excel Quickie 64
Пікірлер: 23