Quickly Select Entire Sheet
I’ve talk to several people the last few days that weren’t aware of this simple trick. Instead of using your mouse to select all the cells on your spreadsheet, Excel has a built-in way of quick selecting everything.
By clicking in the top-left square, above the row numbers and left of the column letters, you can quickly select your currently active spreadsheet. This can be useful if you want to select everything and copy it to another sheet, or if you want to quickly delete everything selected. Check out the image below:
Excel Keyboard Shortcuts
Using these Microsoft Excel shortcuts will greatly decrease your time spent doing simple operations. This is not an exhaustive list of available shortcuts, only commands that I have found useful through my experiences. I’ve found that the best way to see if any of them will work for me, is to try a couple at a time and get used to using them. Over time, they can gradually increase your productivity if you give them a chance.
Comments Re-Opened
I just realized that for however many months, the comments section of each post has required registration in order to post your comment. That feature has now been disabled, and all you need to enter now to post a comment is your name and email.
Sorry for the extra post regarding this, but I wanted to get the word out that Excel Hint’s comments have been re-enabled. I have been asking for feedback/comments and the section wasn’t allowing it. Thanks for your patience.
Thanks,
John
** Excel Hints provides Excel Tips and Excel Help for All Levels of Experience.
Print Column Headers On Each Page
Have you ever wanted to print the column headers at the top of each page to make reading the document easier. Well Excel provides an easy way to accomplish this task in only a few steps.
To have Excel show column headers at the beginning of each page during a print job:
Read More
Excel Hints Redesign
With more readers everyday visiting Excel Hints, I’ve decided it’s time to make some additions and changes to the site. If you’ve visited the site in the past, I’m sure you will notice the new design of the website. I’ve received both positive and negative feedback so far, and I appreciate anyone that wants to leave a comment as far as their feelings about the site layout and design (please just use the comment form below if you feel like it).
So in addition to the newly opened Excel Forum, and the site design, we also recently reached a milestone by going over 100 subscribers. I am currently working on a contest to be held on this site to thank everyone for their interest in the Excel Hints. More information to come on this soon.
John
** Excel Hints provides Excel Tips and Excel Help for All Levels of Experience.
