- #Excel 2008 tutorial for mac code
- #Excel 2008 tutorial for mac plus
- #Excel 2008 tutorial for mac windows
I am pretty annoyed at how difficult Microsoft makes this basic preference configuration, and a little surprised that nobody is bashing Microsoft about it.
#Excel 2008 tutorial for mac windows
xltx from the file name in the finder.Īs pointed out by the original hinter, this won't fix the zoom problem for old saved files, but it will make new windows zoomed, which is good enough for me. Change the finder prefs (not system preferences) then select "show all filename extensions." I am not positive but I think this defaults to off, which makes the finder automatically hide extensions, so you think you've saved your excel template "workbook" without an extension but really it is just hidden.Ģ. The part about making absolutely sure the suffix is not part of the file name was trickier than it seems. While this method isn't as elegant as the above AppleScript, it works pretty well for my needs.]Įde's comment above does work to set a default zoom level for new windows, but there was an extra step for me to get it to work. Repeat the above steps for Zoom Out (Control-Option-minus), and you've got handy shortcuts to precisely set the zoom levels. (For previous versions of OS X, you'll need to quit and relaunch Excel to see the new shortcut.) Enter the shortcut you'd like to use (Control-Option-plus or whatever), and (if you're running 10.5) switch back to Excel 2008 and try your new shortcut.
#Excel 2008 tutorial for mac plus
Click the plus sign to add a new shortcut, set Excel 2008 as the application and Zoom In as the menu title. Click OK to close the dialog in Excel, then open the Keyboard Shortcuts tab of the Keyboard & Mouse System Preferences panel. Drag and drop it onto a menu where you'll be able to find it - I placed it at the bottom of the View menu. Now drag Zoom In from that dialog up to the small representation of the main menu that appears just below the actual menu bar. Click on All Commands in the left-side box, then scroll down and find Zoom In in the right-hand box. Go to Views » Customize Toolbars and Menus, then click on the Commands tab. As an alternative, you can create keyboard shortcuts for zoom in and zoom out, which is what I've done. The control isn't all that precise, though, and you have to scroll very slowly to find the exact zoom level you want. You can, of course, use the mouse to zoom the sheet - Control-Command and scroll wheel in 10.5 will increase or decrease the zoom level. You can modify the Normal template, I believe, to force new documents to appear at your chosen zoom level, but that won't affect existing documents. [ robg adds: I searched the net for a simpler way to make all documents appear at a higher zoom level, but didn't find an easy answer. For some reason Excel likes to hide at a previous step sometimes. Set errMsg to "There was an error with your last input.rr" Verify the entered text can be converted to a number. Repeat while (output 400) -The range of Excel's zoom is 25-400%ĭisplay dialog errMsg & "Please enter a Zoom Factor to use with all documents in Excel (25-400):" default answer zoomFactor buttons Tell application "Microsoft Excel" to activate Make sure Excel is running to begin with.
When Excel quits, the assistant should quit too. The current windows are next check's old windows. If prevWinNameList contains name of anWindow then Compare current windows to the last check Repeat with anWindow in currWinList -i from 1 to (count of currWinList) Set currWinNameList to name of every window Tell application "System Events" to set ExcelIsRunning to (name of processes) contains "Microsoft Excel"
Tell application "Microsoft Excel" to open theseFiles
#Excel 2008 tutorial for mac code
This code was originally written by Mike Cramer on.
0 kommentar(er)
