- For Mac Excel 2016 I create this add-in that add a menu item called 'Insert Sheet Template' to the bottom of the menu that you see when you Rightclick on a sheet tab on the bottom of your Excel screen. Download Add-in for Mac Excel 2016 (File date 17-March-2018) How to install the Add-in after you unzip it on your Mac. Open Excel 2016.
- Move to the Tell me or Search field on the Ribbon and type a search term for assistance or Help content. Alt+Q, then enter the search term. Open the File page and use Backstage view.
One of the resources available for Office is the ability to combine two important programs that we use daily, such as Word and Excel. It is a way to link spreadsheet data with your Word document in only one file
To create an Excel spreadsheet in Word :
You want to scroll, but you want to see your top row or left column to stay still. To do this, you use the Freeze buttons on the View tab. If the Freeze buttons aren't available on the View tab, make sure you. I have transferred my Workout Journal spread sheet over from my girlfriends PC (which I use often). Problem is, I can't access it the file on my Mac in Excel or Numbers. It's currently in.xlsx format, I tried simply renaming as an.xls file but it wouldn't open properly on either application.
Imagine that you have a Word document and you have to insert an Excel spreadsheet. Click on the Insert tab and choose the Table button, then click the item Excel Spreadsheet.
You will see the Excel window inside your Word document.
Arrange your spreadsheet by inserting your data and setting your format. You can also add formulas.
Now you simply have to click outside of the worksheet to return to your Word document.
| Click here to return to the 'Create 'ledger paper' in Excel' hint |
How To Create Excel Sheet In Macbook
You can also format every 3d, or every 4th row (sometimes easier on the eyes) by using MOD(ROW(),3) or MOD(ROW(),4).
Great hint Rob. I've been looking for a more convenient way to do exactly this.
This is truly one of those things that, if you use Excel on a day-to-day basis and know the formulas 'intimately,' it would seem obvious. However, for hacks like myself who need this type of hint to save them an hour of work trying to reformat those dang cells.. Download free sims games for mac. THANKS!
OH MY GOD! Thank you so much. I've been wanting to do this for so long. In fact, just the other day I was commenting to a colleague on how I wish there were an obvious way to do this, but I could never find it. Lo and behold! Two days later, here it is on Mac OSX Hints. This is why I love this site and read it every day.
Thanks again!
I have been able to run the macro on the sheet I have open, but how do I get the macro to live in all new documents I create?
From Excel Help:
If you want a macro to be available whenever you use Excel, store the macro in the Personal Macro Workbook in the Microsoft Office X->Office->Startup->Excel folder.
Note that this file is usually open, but hidden, every time you start Excel. It should be listed in the drop down menu for places to save a macro, and you should be able to 'unhide' it from the Window menu.
Nice think but as I don't do Excel and most of my 'tables' are in Filemaker I was searching for something similar for ages. I tried several things and it's not that complicated to create colored background using formulars but somehow I never got the 'alternating' thing work. :-(
it didn't work for me (using office 2004), until i changed the formula to this: =MOD(ROW();2)=0
which means changing the comma into a semicolon..
Using Office 2004, I get an error using the semicolon:
=MOD(ROW();2)=0
Odd..
I think it depends on the your localisation settings. When your system is set to French you have to use semi-colons, whereas in English you use commas.
Balázs
On my Excel, French version, I need to use LIGNE instead of ROW.
German Office users need to use the following formula:
=REST(ZEILE();2)=0
Yes, it seems that you localisation DOES count.
In french version of Excel, you must use semi-colon (;) and LIGNE (instead of ROW)
So if your OS system localisation is 'French' (France, Canada, etc), you most likely use semi-colon (;) instead of colon (:) even if you have an english version of Excel (in wich case you would use 'ROW' insted of 'LIGNE' for the French version)..
Well, you got the idea..
- Details and links here.
I usually just select the area that I want every other line shaded. Then use excel's Format -> AutoFormat -> List 1 2 or 3. Ccleaner para mac os x. You can change things like the formating and boarders in the options.
Yes, but then things get screwed up when you delete or insert lines.
Nice hint, but I would suggest it has nothing to do with OSX. At the very least, I wouldn't look here fo that kind of things. Rather in a Excel-related site.
Sorry about the rant..
The site has had an 'Applications' category since day one, and it's one of the most popular here -- nearly one-third of the hints on the site fall into the Apps category. Technically, *none* of those are OS X related hints, and they should all go if I were holding hard and fast to the site name. And don't forget about the Web Browsers category; that's basically another Apps bucket with about 5% of the total posts on the site.
As a registered user, though, you can take care of this issue yourself -- just use the Display Preferences and disable the Apps category (and any others you don't want to see), and you won't see any more hints in the category.
The site name is potentially a bit confusing; it might be clearer if it were something like 'Mac Hints,' but the intent has *always* been to create a site that contained the very best tips and tricks for using OS X. And what fun is it to use an operating system if you never run any applications on top of it? Clearly we'll never try to become 'exceltips.com' or 'photoshopwizards.com,' but I will run hints that seem to be helpful to readers of the site .. judging by the comments, I think this one fits that category.
regards;
-rob.
How To Create Excel Sheet
One of the first things I do every weekday morning is visit MacOSXHints to look for ideas and tips that will help me more effectively understand and more affectively use OS 10.3.5 and and my applications, chief of which is Office 2004, including its Excel component.
Look to other sources for info on Excel? I subscribe to the Microsoft Excel Newsgroup among other newsgroups and include in my daily browsing such forum components as MacWorld's.com's Business software forum and MacFixIt.com's Microsoft Office forum. But it was this Thursday in MacOSXHints that I found this pure, solid gold hint.
This Excel hint is clear, concise and interpretive. As a communications researcher, author and professor, I salute Rob on the value, substance and presentation of it.
I copied the hint verbatim together with some ideas I picked up from the comments into my Entourage Notes and already applied it to several spreadsheets, thank you very much.
Respectfully, Norm Nager
Create Master Sheet In Excel
I like things just the way you are running them now, robg. Don't go changin'. Keep up the good work. I, too, check macosxhints first thing every weekday, to start my day, learn some new things, and, very often, improve my experience with OSX.
---
--
osxpounder
Totally agree.. App Hints as well as System Hints are making OSXHints so much more than just a mac Website..
BTW, Could there be a way to 'save' some hints I could take a quick look at my prefered (or most usefull) hints later on?
thks - keep it going Rob!
Is there a way to make COLUMNS alternately shaded? I tried substituting the word ROW with COLUMN, but it did nothing. Can it be done?
I'm able to sub COLUMN for ROW and get the intended result. A typo maybe?
I tried it again - it seems to work - maybe it was a type - perhaps I put COLUMNS instead of COLUMN???
Thanks
In case it should be relevant to anyone who prefers to steer clear of Microsoft, it is possible to achieve the same effect in the RagTime spreadsheet module by giving the active layer a transparent fill and placing it over a striped under-layer.
I would love to know whether any other X-compatible spreadsheets can be reliably striped.
I love this hint. But does anybody know how I can create the ledger paper and then also bold rows according to a condition? It seems Excel will only do the latest condition and not apply multiple formatting.
Sorry if this doesn't make sense -- first cup of coffee and all.
Thanks.
