|
|
You open lots of Excel files every day, and sometimes open the same file several times. In Excel 2007, if you click the Office Button, you can see a list of documents that you've opened recently. Click on file name, to open that file again.
Change the Number of Documents
My Recent Documents List was showing 17 files, and I guess that's the default number, since I don't remember changing it. Instead of leaving the default setting, you can show more or fewer files.
To change the setting:
Click the Office Button, then click the Excel Options button Click the Advanced category In the Display section, change the number for Show this number of Recent Documents. Click OK, to close the Excel Options window.
The maximum number of files is 50, but that many might not show unless you have a really tall monitor.
Change the Setting in
Continue reading Stick to the List in Excel
Almost a year ago, we talked about creating a table of contents sheet in Excel. In that post, one of the suggestions was to type a list of sheets on a worksheet, then change each sheet name into a hyperlink.
Create Hyperlinks By Dragging
Well, forget all that typing -- here's a method that's even easier. Instead of typing, you can drag cells to create hyperlinks.
In this example, there's a table of contents sheet (TOC), a Sales sheet, and an Expenses sheet. We'll create a hyperlink to the Sales sheet, on the TOC sheet.
First, save the workbook, if you haven't done so already. If you're in a new workbook, that hasn't been saved, this technique won't work. Next, select a cell that you want to link to. In the screen shot below, the Sales sheet is activated and cell A1 is selected. Point to
Continue reading Creating Excel Hyperlinks Is a Drag
John Walkenbach is having a 2 hour sale of his Power Utility Pak (PUP) – over 80% OFF the regular price. You can get all your Christmas shopping done early, if you act fast! I'm sure that all your family and friends would love an awesome Excel utility.
The PUP sale is Tuesday, November 3, from 11:00 am to 1:00 pm U.S. Eastern Daylight Time (that's 4:00 pm – 6:00 pm GMT).
Go to his Special 2-Hour Sale Order Form to buy either version:
PUP v7: $7.77 (normally $40.00) PUP v6: $6.66 (normally $39.95) The complete VBA source code is available for an additional $20.00
If you'd like to see the PUP utility before you buy it, you can download a trial version.
PUP Features
John sent me a complimentary copy of PUP v7 last year, and I reviewed it here. I still highly recommend it, so if you've ever
Continue reading How Much Would You Pay For an Excel Utility?
|
|
Recent Comments