Home » Resources » MINT Tips » MINT Tips - Excel

MINT Tips - Excel

  • To close all open Excel documents at once, hold down the SHIFT key when you click on File, this will change the Close option to Close All.

 

  • Copy formulas by Clicking on the Cell with the formula, Ctrl+C (copy), then move to the cell you want the formula to go into  and press Enter – now copy a formula, and Highlight a series of cells and push enter, the formula will copy into each cell and keep the relative row/column info.

 

  • Click the box above Row 1, and to the left of Column A to select the entire sheet. Entire sheets can be copied to new sheets by selecting the sheet, clicking on the “Sheet 2” tab, and Ctrl+V (paste). This will retain formulas and formatting, very handy if you want to test some changes in a worksheet.

 

  • If you want to change a series of cells to the same format (Numbers, currency, text, etc) as another cell, then highlight the original cell and click the Format Painter button (Paint Brush), then select the cells you want to change – you can select a single cell, or a range of cells, an entire column or even the entire worksheet. If you have lots of individual cells to change, then double click the Format Painter button, now every cell, range etc that you click on will change its format to that of the original cell. When you’re finished, you will need to click on Format Painter again to turn off the function.

 

  • Use Print Areas to print only part of a worksheet, Highlight the section of the worksheet you want to print (or export to pdf), and click File, Print Area, Set Print Area. Now when you hit print, only that area of the worksheet will print out.

 

  • Worksheet just too wide for the printer? Click File, Print Preview – here you can click on the margins button and slide them across to fit more info onto the page.

Also, if you click Page Setup from the Preview page, you will see an option to Fit to X pages Wide and X Pages long (you can select 1 page wide and 100 pages long if you don’t know how many pages long the sheet is, it will only print the pages with data on them).