Featured Excel Guides Archives

Excel worksheet with the UPPER formula in the formula bar and uppercase results in column B

How to Make Text Uppercase in Excel 2013

September 28, 2026December 14, 2022 by Kermit Matthews

Make text uppercase in Excel 2013 and later with the UPPER function or Flash Fill, replace the original text, and use LOWER and PROPER.

Shape Format tab with the Shape Fill menu open and No Fill highlighted

How to Remove Fill Color From a Text Box in Excel 2013

September 28, 2026December 8, 2022 by Kermit Matthews

Remove the fill color from an Excel 2013 text box: select its border, open Format, Shape Fill and choose No Fill. Remove the outline too if needed.

Spreadsheet Page Setup dialog on the Sheet tab with Rows to repeat at top set to row 1 highlighted

How to Include a Title at the Top of Every Page in Excel 2013

September 28, 2026December 8, 2022 by Kermit Matthews

Print a title on every page in Excel 2013 with Print Titles and Rows to repeat at top, or add it to the header, plus fixes when Print Titles is grayed out.

Spreadsheet with rows 4 to 6 selected and the right-click menu showing Hide

How to Hide Rows and Columns in Excel 2013

September 28, 2026December 8, 2022 by Kermit Matthews

Hide rows and columns in Excel 2013 with right-click, the Format menu, or Ctrl + 9 and Ctrl + 0, unhide them again, and hide individual cell contents.

Spreadsheet with a bar chart selected and its right-click menu open with Save as Picture highlighted

How to Save an Excel Chart as an Image (PNG, JPG, or SVG)

September 25, 2026December 8, 2022 by Kermit Matthews

Save an Excel chart as an image with Save as Picture on Windows or Mac, choose PNG, JPG, or SVG, and use copy-paste or screenshots in Excel for the web.

Spreadsheet Page Setup dialog on the Sheet tab with Rows to repeat at top set to $1:$1 highlighted

How to Print the Top Row on Every Page in Excel 2016

September 27, 2026December 8, 2022 by Kermit Matthews

Print the top row on every page in Excel 2016 with Page Layout > Print Titles, repeat columns on the left, and fix a grayed-out Print Titles button.

Spreadsheet Page Layout tab with the Breaks menu open and Reset All Page Breaks highlighted

How to Remove All Page Breaks in Excel 2013 (and Newer)

September 25, 2026December 8, 2022 by Kermit Matthews

Remove all page breaks in Excel with Reset All Page Breaks, delete single breaks in Page Break Preview, hide dotted lines, and control breaks with scaling.

Excel Page Setup dialog on the Margins tab with Center on page Horizontally and Vertically checked

How to Center a Worksheet Horizontally and Vertically in Excel 2010

September 24, 2026December 8, 2022 by Kermit Matthews

Go to Page Layout, open Page Setup, and on the Margins tab check Horizontally and Vertically under Center on page. How to preview and apply to many sheets.