Useful toolbar buttons you don't see every day in Excel 2003, Part 3
September 25, 2009 • JP • No Comments • Rate This Article
• Links to this article
This is the last post in the Useful toolbar buttons you don't see every day Series. To view previous entries, visit:
Let's finish up with the Format, View and Edit menus. Each of these has a few useful commands you might want to keep handy on one of your Excel toolbars.
Format this!
I found the following commands on the Format Menu. The best place for Double Underline would be next to the existing Bold / Italic / Underline buttons. Like the name says, this command adds double underline formatting to a cell. Although I find that the underline is too close to the letters in the cell, making it harder to read, it certainly makes the cells stand out. Double Accounting is better (Format » Cells » In the Underline listbox, select "Double Accounting") because the spacing between the cell content and the double underline is greater.
- Double Underline
- Strikethrough – can also be toggled with Ctrl+5
- Cycle Font Color
Cycle Font Color is more of a parlour trick, and I can't tell what method it uses to loop through the font colorindex, but it's fun when you are bored.
View Menu
The View menu has three commands that are somewhat handy. You can actually toggle the visibility of the formula bar and comments, and the most interesting one: HTML Source, which opens the Microsoft Script Editor where you can view the HTML version of the workbook.
- Formula Bar
- Show/Hide Comments
- HTML Source
And here's the (partial) HTML source for a brand new workbook:
Edit Menu
I found five commands on the Edit menu worthly of their own place on a toolbar.
- Clear Contents
- Clear Formatting
- Delete Comment
- Select Visible Cells
- Select Current Region – same as Ctrl+Shift+8 or Ctrl+*
These should be self-explanatory, they're on the traditional Edit menu or the right-click context menu.
Excel ·
Rate This Article:
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: More Outlook.Application Best Practices
Next Post: Finding values in an array without looping
From the Format menu, I add Unmerge cells and Lock cell buttons to my custom toolbar.
Also, I add the Top border command to the Borders palette
Format buttons they should have, but don't — Centre Across Selection, and Wrap Text.
You could always write macros for those functions, then add them to a toolbar that way.
Yeah, I do that
They've finally add Wrap Text in 2007, but still no Center across Selection.
Press the Shift Key, keep it pressed and click on the Underline button to get double underline…. Why waste screen estate
BTW the Underline is now a splitbutton in 2010…
Actually I miss this approach to toolbars in 2007. The quick access bar is only a surrogate.