Archives for Excel Tips

If you are like me, you like pretty spreadsheets! Two features that I use on almost every single spreadsheet that I create are wrap text and column and row width adjustment. Wrap Text is helpful for fields that have a lot of text in them, like a comments or notes column, for example. I like to apply wrap text to these fields so that I can see all the info...

Read More About Excel Tips & Tricks – Wrap Text and Column/Row Width

Do you ever review a spreadsheet and highlight information that is important to you or pertinent to a current project? In Excel, this function is called Conditional Formatting and it is available right on the home tab. Let’s say you want to highlight any amounts in your spreadsheet that are between $1,000 and $10,000. Highlight the area you want to searc...

Read More About Excel Tips & Tricks – Conditional Formatting

Excel has a built-in formula for concatenation. It looks like this: =concatenate(A2, B2) or = concatenate(A2,””, B2) This works, but I am blogging about shortcuts! There is another way to perform the concatenate function. You can also use the “&” symbol: =A2&B2 or =A2&””&B2 Imagine you have a spreadsheet with a column for First Name and a...

Read More About Excel Tips & Tricks – Concatenate: It’s simpler than you think!

Control, Shift, Down is a shortcut that I use so much, I think I could do it in my sleep. This function allows you to quickly and easily highlight sections of information within your spreadsheet without having to use the scroll button or toolbar. For example, I want to highlight an entire column of data so I can copy it into another column. I would select...

Read More About Excel Tips & Tricks – Control, Shift, Down

Have you ever scrolled through a spreadsheet and suddenly realized, you have no idea what data belongs to which column? There is a function in Microsoft Excel called “Freeze Panes.”  This feature allows you to freeze the column headers of your data so that it remains on the page while you scroll. Let’s try it out! In your spreadsheet, select the first cel...

Read More About Excel Tips & Tricks – Freeze Panes

If you haven’t used the Auto Filter feature in Excel, your life is about to change! Auto Filter allows you to categorize and filter data seamlessly. It is especially helpful when you have several columns of data and you want to see only portions of this data. Let’s assume we have a spreadsheet full of names, phone numbers, and addresses (city, state, zip)...

Read More About Excel Tips & Tricks – Auto Filter

Do you use the format painter? I do! I use this feature all the time in Excel and I find it saves so much time. The format painter is on the home tab and it looks like a little paintbrush. The purpose of the format painter is to copy the exact formatting of one field, column, row, or sheet to another field, column, row, or sheet. For example, let’s say yo...

Read More About Excel Tips & Tricks – Format Painter