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
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
New Excel Forum
Excel Hints has continued to grow over the last year and since we are approaching 100 subscribers (I’ll definitely have another post when we pass the milestone), I have decided to add a new Excel Hints Forum to the site.
I believe if we can get users to register and begin posting, this can become an invaluable tool to getting everyone’s questions answered as quickly as possible. With my full time job, I don’t always have time to answer everyone’s questions I get through email, so I think this is the perfect solution to that. I’ll answer as many questions as I can through the forum and hopefully we can get other’s to help out too if they know the answer.
Read More
Quick Way to Check for Duplicates in a Column
I have been using this quick trick lately to check for duplicates in a column of values. Let’s say you have a list of a large group of numbers (characters work as well) and want to see if you have more than one instance of any of the numbers. To check for that, one simple was is to use the CountIf formula.
I have already shown you how to use the formula in the SumIf and CountIf Foumulas post. But here I just wanted to mention this is an example where you can use it.
Let’s say we have a column, say column D, with 100 values that you want to confirm do not have any duplicates. To check this, in a column next to the data you are dealing with you can add this formula:
Read More
Loading ...