Word and Excel Stocking Stuffers
Because today is Christmas Eve, I thought I would share a few little Word and Excel stocking stuffers with you!
For instance, want a quick way to fill an entire column with a formula? Enter your formula in the first cell of the column. Select that cell. Not press Ctrl+Shift+the down arrow key. This will select the column all the way to the end. Press Ctrl+D and your formula will make its merry way down the column.
Need to insert a row or column and just don’t feel like moving away from the keyboard? Press Ctrl+Shift+= and the Insert dialog box will appear.
Want to add a page break without going through the rigmarole of going all the way up to the Insert menu? Ctrl+Enter will do the trick for you.
You can quickly scroll through pages of a Word document by pressing Ctrl+Page Up or Ctrl+Page Down. This will take you directly to the top of the next or preceding page.
Promptly remove tabs from a document someone sent you – or one you created but need to reformat – by selecting the entire document (Ctrl+A is a quick way). Double click the middle of your horizontal ruler and the Tabs dialog box will open. Click Clear All and you are all clear!
Double click elsewhere on the ruler (you do not have to have the text selected) and you have yourself the Page Setup dialog.
Finally, double click the small square button just above the scroll bar on the right and you have a split menu!
Tricia Goss, Editor
tricia@officeusers.org
Your Office Answers are Here!