Back to Blog
That is, if you select a single cell, it will insert one row. Plus, it inserts the same number of rows as the selected range. There are other shortcuts, but I prefer this one because it does not require me to select the entire row first or respond to a subsequent dialog box asking if I’d like to insert cells or a row. To insert a new worksheet row, I use Alt+I, R (for Insert Row). If not, I believe holding Fn and Down arrow does the PageDown, so, you’d use Ctrl+Fn+Down 2) Alt+I, R Mac Users: depending on your keyboard, you may or may not have a PageDown button. Ctrl and PageUp activates the previous worksheet. When you press and hold the Ctrl key, and then hit the PageDown button, Excel activates the next worksheet. Here are 3 shortcuts that I use on a daily basis: 1) Ctrl+PageDown/PageUp So, in this post, I’ll talk about 3 of my most-used shortcuts and then show you how to easily figure out the shortcuts for your most-used commands. You see, the faster you can communicate with Excel the faster you’ll get your Excel-work done. In addition to knowing which features and functions can help you work faster in Excel, knowing a few keyboard shortcuts will help as well.
0 Comments
Read More
Leave a Reply. |