Category Archives: Excel

Excel: Extend Page Setup Settings to Other Sheets

 

SCENARIO – You have a multi-sheet Excel file. You have applied numerous Page Settings to Sheet1:

• Landscape orientation
• Legal size
• Custom ½” margins
• A custom footer
• Print-to-fit scaling
• Print titles (to repeat at the top of each page)
• Single-side printing

 

You would like the other sheets (Sheet2, Sheet3, etc.) to have the same Page Settings – without having to repeat the steps on each page.

 

No problem-o!

 

Full tip: Excel tip

Read Less

Excel: Removing All Blank Rows

 

Full tip here: Excel tip

Read Less

Excel: Where’d it Go?

 

Ok – here it is. One very short tip. Don’t blink or you’ll miss it.

 

We’ve all done it – you select a range of cells…then scroll away to look at another part of your spreadsheet.

 

Now, if this is a BIG spreadsheet, you’ll find yourself either roaming (scrolling) around trying to find your way back to the selected range when you’re ready – or zooming w-a-y out so you can find it again.

 

Full tip: Excel tip

Read Less

Excel: Sweet Little Keyboard Shortcuts

 

I love keyboard shortcuts – as long as they’re fast and easy.

 

So, here are a few gems to use in Excel…

 

Full tip: Excel tip

Read Less

Excel: Transposing Columns-to-Rows and Vice Versa

 

Have you ever entered a spreadsheet then realized that you should have had the one set of headings go ACROSS the spreadsheet (instead of down) and the other set of headings go DOWN the spreadsheet (instead of across)?

 

You can quickly and easily transpose the data…

 

Full tip: Excel tip

Read Less

Excel (Advanced): Dependent Data Validation Drop-Down Lists

 

You can limit the choices in an Excel data validation list, by using named ranges and the INDIRECT function, to create dependent data validation lists.

 

Full tip: Advanced Excel tip

Read Less

Excel: Shading Alternative Spreadsheet Rows

 

Method #1: Format as Table

 

Method #2: Conditional Formatting

 

Full tip: Excel tip

Read Less

Word/Excel: Trust me – I’m a doctor

 

If you are constantly opening up files (from a source you say is good – like a shared network drive) – and Word, or Excel, is displaying the Protected View banner….you can disable this.

 

Protected View is a read-only mode in which most of the editing functions are disabled to help protect you from potentially malicious software.

 

But if you’re opening up files from a source you know and trust – like a shared drive…you just have to let Word (and Excel) know that this source is trustworthy.

 

Full tip: Word and Excel tip

Read Less

Excel (Advanced-ish): Using Wildcards in Equations

 

If you need to sum up (the same) cells from a number of sheets – that are all similarly named…this tip is for you.

 

Full tip: Excel tip

Read Less

Microsoft Office: These are a Few of My Favourite Things

 

One great shortcut for each of Word, Excel, Outlook, Windows and PowerPoint.

 

Full tip: Microsoft Office tip

Read Less