It sounds like a lot, but I suspect it is still faster than using the mouse once you get used to it as it is a very common operation. If you mean to fill an entire column, I usually copy ( Ctrl+c), move one cell to the left, go to bottom of that column with Ctrl+Down, move to the right, then select everything to top with Ctrl+Shift+Up, then paste with enter. But you can use Ctrl+r to fill right and Ctrl+d to fill down one cell. Probably prefer to use mouse after that.Ĭell fill handle: I don't use this too much, so I'm not certain. You can also use Ctrl+1 then type ff to go to fill tab. You can then use up/down arrows to change or use mouse. Setting color formatting Alt+h+f+c to change font color, Alt+h+h for fill. But then yes, you need to hit tab or down arrow a few times to get into search box. Searching in filter boxes: Alt+Down to bring up filter menu. I think this one is much faster with mouse. If you need to move to another workbook, Alt e m like moving, but then Shift tab to choose what workbook you want to move to. If you want to copy sheet, use Alt c to copy after you hit Alt e m to start. Moving workbook tabs around: Alt e m then up/down arrow to move to another location or start typing the name of the sheet. Once that menu is open, I agree - using the mouse is easier. For some of the items you mentioned with regards to Excel:Ĭustom sorting: Alt d s to bring up sort menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |