|
|
I keep track of my tasks in an Excel file, where I have macros that export the completed data to Access for invoicing.
I check the list every morning, and at the end of the day, but not very often throughout the day. So, while I might have an excellent plan for the day, it [...]
As you work in Excel, the files that you've used most recently appear at the bottom of the File menu. The default number of files that appear is 4, and you can increase this to 9, in the Tools>Options dialog box, on the General tab.
If you'd like more than 9 entries, and some [...]
Do you know that just like us, paper has a good side, and a not-so-good side? And the good side is better for printing. Paper grain affects printing too, but we'll save that excitement for another day. (Yes, I grew up in a paper mill town, thanks for asking.)
How do you figure out which [...]
Yesterday I posted a tip for adding the Refresh All button to the PivotTable toolbar, so you can quickly update all the pivot tables and queries in a workbook. In the comments, Jan Karel Pieterse mentioned that he can press Ctrl+Shift, or hold the Alt key, then drag toolbar buttons to a different toolbar. I [...]
In one of the Excel newsgroups last week, someone asked how they could update several pivot tables at the same time. They were tired of selecting each pivot table separately, and clicking the Refresh button.
In an Excel workbook you can refresh all the pivot tables and queries if you click the Refresh All button. [...]
Moved to the Excel Twitters archive:
Excel Twitters 20081025
When you're searching in Google, by default it shows you 10 results per page. Sometimes you're lucky and the item you're looking for is right there on the first page. Other times you're not so lucky, and have to look through a few pages before you find your answer.
To cut down on the page [...]
It's been several years (decades?) since I studied Latin, so I can't translate any of this, but when designers need a block of text they often use Lorem Ipsum. This focuses attention on the design, rather than the text.
You could use this when setting up a web layout or Word template, to show [...]
Outlook has an Out of Office Assistant that will notify people that you're not in the office, but unfortunately it's only available if you're using Exchange Server. What about me? I don't have Exchange Server, and like to leave my office occasionally.
If I'll be out of the office for more than a day or [...]
When you insert a comment in Word or Excel your user name is shown in bold at the top of the comment. In Word, the comment is marked by your initials, and in Excel it's marked by a red triangle in the top right corner of the cell.
Perhaps your name has changed, or [...]

|
|
Changing Your Name in Office
When you insert a comment in Word or Excel your user name is shown in bold at the top of the comment. In Word, the comment is marked by your initials, and in Excel it's marked by a red triangle in the top right corner of the cell.
Perhaps your name has changed, or [...]