Hardly a day goes by that we don’t get a question from someone along the lines of “does do , and why doesn’t it?”. Or, there’s the “when will Microsoft change to allow us to do ” question. Bottom line… we don’t know, and we have virtually no sway to influence Microsoft to change their software… but you do!
Tag: Excel
Excel Flash Fill on names
I’m sitting in a training session today, and I saw the trainer do something in Excel that I didn’t know was possible… Flash Fill can complete columns of names based on other columns. Here’s how…
Inserting multiple blank lines in an Excel spreadsheet
This is a really simple tip that I wish I had known about sooner, instead of copy and pasting blank rows for an Excel spreadsheet. Instead of just inserting a single blank row, you can easily insert multiple blank rows by highlighting the number of rows you need. Here’s how…
Excel keyboard shortcuts
Are you the type of person who likes to use keyboard shortcuts when you’re working with software? If you do, here’s a great resource for keyboard shortcuts in Excel.
What in the world is an “Interrobang”?
Today’s tip is a bit lighter in nature, as I learned something this week which I had never even heard, much less knew about. Have you ever written an email or a Skype message that was something along the lines of “What do you think you are doing?!?!?!” That series of snarky question marks and exclamation points, when combined, are often referred to as interrobangs.
Setting the Print Area on an Excel spreadsheet
Obviously, you can have a multitude of rows and columns in an Excel spreadsheet spread out over numerous worksheets. However, if you want to print out just part of the information, you may think you have to print out everything just to get the part you want. In reality, you can set the Print Area of your spreadsheet to only print out the area that you need, saving paper and time in the process. Here’s how you do that…
Adding comments in your Excel spreadsheet
There have been times I would have liked to have made a note or two in a spreadsheet so I could remember something associated with a piece of data. I wish I had known about adding comments, but I do now!
Changing your user initials in Office programs
A colleague pointed out this option to me the other day, and it’s a good one to share. In Office programs like Word or OneNote, the system often uses your initials to note who made changes. But perhaps you need to change your initials for some reason (duplicate of someone else, you don’t like them, etc.). Here’s how you do that…
Additional AutoCorrect options in Office
Recently I talked about how to add and remove particular words and acronyms that Office “helpfully” tries to correct for you. In this tip, I want to point out a few other options that are interesting and might address a pain point or two based on how your fingers and your brain communicate with each other…
