Archive | Excel RSS feed for this section
Excel and Numbers Keyboard Shortcuts
In Excel, press the Option key and click on the heading of a row or column — or drag across more than one — to insert that selection. In Numbers, hover the cursor over the heading and click on the small disclosure triangle to the right of the heading. Select your option. In both applications, an alternative [...]
Continue reading...Excel Efficiency
4. December 2007
Ever looked at a formula and wondered, “What does that mean?” To find out, you usually need to make a note of the cells it uses and scroll around to see the values in each cell reference. The next time you feel compelled to do it, stop! Simply double-click on the cell and voila, Excel selects [...]
Continue reading...Excel needs 4MB of RAM
4. December 2007
If you are thinking of using Excel 4.0, it’s a good idea to have 4Mb of RAM under System 6 and 5 Mb of RAM under System 7. This leaves out the Classics’s, SE’s, and Pluses.
Continue reading...Excel Fractions
4. December 2007
How do I enter a fraction so it isn’t entered as a date? When entering fractions without integer values (such as 1/2 instead of 1-1/2), you must first type a zero followed by a space before typing the fraction. Otherwise, Excel interprets it as a date. For example, if you type 1/2, Excel displays 2-Jan. If [...]
Continue reading...Excel Leading Zero
4. December 2007
To display leading zeros, such as for zip codes, first select the column you want to format. Then choose Number from the Format menu. In the code box, type 00000 ( or 00000-0000 for zip+4) and click OK.
Continue reading...Excel 4.0 Chart Labels
4. December 2007
How do I enter more than one line of text in a chart label? Normally, when you press Return while typing a chart label, Excel assumes you are done with the title. Press either Control/Return or Command/Return to enter additional lines.
Continue reading...Excel Charts — Single Point
4. December 2007
To select a single chart point in Excel, Control/Click on the point By clicking the black handle on the point (or column), you can move the point up and down. Excel will change the data on the spreadsheet to reflect the changes you make to the chart. You can also paste your own graphic when [...]
Continue reading...Excel and PowerBooks
4. December 2007
Since I don’t have a PowerBook, I haven’t tried this — but it sounds reasonable. When you open Excel 4.0 documents created on your office Mac in your PowerBook, not only are they too large for the PowerBook screen, but you probably can’t even see the resize screen. Instead of dragging the document, select New Window [...]
Continue reading...Excel’s Available Commands
4. December 2007
Try this in Excel 4.0. Select one or more cells. Push the Command/Option keys and depress the mouse. A menu appears on your document offering only the commands available for the selected cell(s). I use this all the time and it’s really handy.
Continue reading...Excel and the Shift Key
4. December 2007
When you hold down the Shift key, many interesting changes occur in the way Excel’s menus and toolbars work. Menu changes: Holding down the Shift key while you pull down the Edit menu changes Copy to Copy Picture, Fill Down to Fill Up, and Fill Right to Fill Left. Toolbar changes: When you hold down the Shift [...]
Continue reading...Printable PDF
Roughly once a month, we gather some of the best tips and put them in a printable PDF file. Purchase the current issue or archived copies in OUR STORE.
Your satisfaction is guaranteed or your money back.
Buy Us A Beer
Like what we're doing? Buy us a beer. Tip hunting is thirsty work.
- Emailing Web Pages
- Can I Hide My IP Address?
- Top 10 Favorite FREE Mac Apps
- Consolidate Your Music Library
- Using Disk Utility
- Super-Fast Way to Email a URL
- Three Audio Tips
- iPhone 3G S: Importing Videos on a Mac
- Mac X Password
- The Hidden '.com' Button in Mail
- llinsi gharei: Such a wonderful topic for me,i read this article ...
- My Leones: Nice blog man Thank you...
- Naveed: how can v instal os x on power book? coz power bo...
- Rob: I've found the free trial of Back-In-Time is reall...
- enhancement products: Thanks for your tips. Surely they seem very good. ...
Apple News 
Details about the iPad
Apple’s new page detailing all the uber delicious iPad features can be found here. I want one now!
Antiglare Display Option For 15-inch MacBook Pro Now Available
If you prefer a display with antiglare coating for a matte rather than glossy viewing experience, an antiglare display is now available as a configure-to-order option on all 15-inch MacBook Pro models. This display has a silver aluminum bezel, which is the same as the 17-inch antiglare MacBook Pro display.Google CEO Schmidt leaves Apple board
In a statement, Apple CEO Steve Jobs cited potential conflicts of interest in explaining Schmidt’s resignation.
“Eric’s effectiveness as an Apple board member will be significantly diminished, since he will have to recuse himself from even larger portions of our meetings,” he said.
Apple is racing to offer a portable tablet-sized computer in time for the Christmas shopping season, in what the entertainment industry hopes will be a new revolution.
via Financial Times.
14. April 2009
0 Comments