Being Social

Do you spend a good chunk of your day on Facebook? If you do, you may want to check out our ExcelTips presence on the platform. You can find us here:

     https://www.facebook.com/excel.tipsnet/

I would love it if you like what you see there if you would really "Like" what you see there. (Got that? Good!) Clicking the Like button means you are more likely to see what we post there.

—Allen
     

ExcelTips (menu) for 16 June 2018

Powerful spreadsheets
Copying Styles

Styles can make your worksheet formatting easier and more consistent. Here's how to copy styles from an existing workbook to another one.

Read this tip »

 
Powerful spreadsheets
Removing All Formatting

Getting rid of formatting from a cell or group of cells can be done using several different techniques. This tip describes the techniques available to you.

Read this tip »

 
Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

 
Powerful spreadsheets
Selecting the First Cell In a Row

When creating macros, you'll often have a need to select different cells in the worksheet. Here's how to select the first cell in the row.

Read this tip »

 
Files
Finding the Parent Folder

Do you need to figure out the name of the parent folder of whatever folder a worksheet is in? Believe it or not, this can be done with a worksheet formula.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450