Top Nav

Tag Archives | excel 2011

Developer Tab

MS Excel: Add Up/Down Buttons to Spreadsheets

Here’s how to add up and down buttons to your Excel spreadsheets. First enable the developer ribbon. On the developer ribbon, click Insert >> Spin Button. Next click the cell where you want the spin button to appear. Next select the Spin Button. On the developer ribbon, click Properties. An options box appears. Click the control tab. Enter values if […]

Continue Reading · 0
Jail Cell

Remove Empty Cells in Excel 2007 or 2010 Spreadsheets

  Ready to remove those pesky empty cells in Excel? Here’s how to do it. Open your spreadsheet and press [Ctrl] [A] to highlight the entire document. Or highlight just the section of the spreadsheet where you want to remove empty cells. Now, press F5 on your keyboard. The Go To menu will appear. Click the Special button. The […]

Continue Reading · 23