Tired of inserting the trademark symbol from the menu? No problem! There's a keyboard shortcut for it. To insert the trademark symbol, just press:
Ctrl + Alt + T
Tada!™
Read More
Ctrl + Alt + T
Tada!™
Funny. When I wrote "greyed out" in the title, it occured to me that Americans don't spell it that way. In the interest of your search engine of choice finding this page, I've written both spellings. Being Canadian, however, I am inclined to write "grey".
Anyway, on to the point of this post: why on earth would the Custom Views button be greyed out?!
The answer to this question might seem very bizarre to you, but the reason why you are unable to access the 'Custom Views' button is because you have used Excel Tables somewhere in your workbook.
That's right. If you've used one or more Excel Tables anywhere in your workbook, you will find that you won't be able to use the Custom Views anymore. I won't lie, I think this is an unfortunate bit of functionality (or non-functionality) but... if you absolutely must use Custom Views, you're going to have to either remove those Excel Tables and convert them to regular ranges, or use some VBA coding to create your own Custom Views.
I know, it's not the best news I could deliver. At least you know why that button's greyed out, though!
Read More
Anyway, on to the point of this post: why on earth would the Custom Views button be greyed out?!
The answer to this question might seem very bizarre to you, but the reason why you are unable to access the 'Custom Views' button is because you have used Excel Tables somewhere in your workbook.
That's right. If you've used one or more Excel Tables anywhere in your workbook, you will find that you won't be able to use the Custom Views anymore. I won't lie, I think this is an unfortunate bit of functionality (or non-functionality) but... if you absolutely must use Custom Views, you're going to have to either remove those Excel Tables and convert them to regular ranges, or use some VBA coding to create your own Custom Views.
I know, it's not the best news I could deliver. At least you know why that button's greyed out, though!
I'm in the midst of writing a number of different papers for a university course I'm currently taking, which has inspired me to share with you the keyboard shortcuts for inserting a footnote, or inserting an endnote.
Alt + Ctrl + F: inserts a footnote
Alt + Ctrl + D: inserts an endnote
I love keyboard shortcuts. You might find they take a bit of extra time when you first start using them, as you struggle to remember them... but I promise that they end up helping you work so much more efficiently once you've got them committed to memory.
Read More
Alt + Ctrl + F: inserts a footnote
Alt + Ctrl + D: inserts an endnote
I love keyboard shortcuts. You might find they take a bit of extra time when you first start using them, as you struggle to remember them... but I promise that they end up helping you work so much more efficiently once you've got them committed to memory.
Did you know that you can make any text box or shape display a value from a cell in your spreadsheet?
The process to link a cell to a text box or shape is really quite simple. Select the text box or autoshape, and now go to the formula bar and type in an equals sign and the address of the cell that you would like to display. For example, to show the contents of cell A3, I would type:
=A3
If it's in another worksheet, it's not problem! For example, to link it to cell B6 in the second worksheet, I would type:
=Sheet2!B6
After you've entered your formula, just press the Enter key and you'll see your text box or shape is displaying the contents of the cell you've chosen.
Happy linking!
Read More
The process to link a cell to a text box or shape is really quite simple. Select the text box or autoshape, and now go to the formula bar and type in an equals sign and the address of the cell that you would like to display. For example, to show the contents of cell A3, I would type:
=A3
If it's in another worksheet, it's not problem! For example, to link it to cell B6 in the second worksheet, I would type:
=Sheet2!B6
After you've entered your formula, just press the Enter key and you'll see your text box or shape is displaying the contents of the cell you've chosen.
Happy linking!
Subscribe to:
Posts (Atom)
Posts
