Create a new spreadsheet and edit it with others at the same time — from your computer, phone or tablet. Free with a Google account. To open Numbers, click the Numbers icon in the Dock, Launchpad, or the Applications folder.
| Click here to return to the 'Create 'ledger paper' in Excel' hint |
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. 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.
https://softwarestuff.mystrikingly.com/blog/roblox-lumber-tycoon-hack-the-cheat-for-mac. Using Office 2004, I get an error using the semicolon:
=MOD(ROW();2)=0
Odd. Google mac management tools.
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.
I usually just select the area that I want every other line shaded. Then use excel's Format -> AutoFormat -> List 1 2 or 3. 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.
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 <b>and</b> 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. <b>But</b> 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
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. https://benonmaistouf1980.mystrikingly.com/blog/cleaner-app-clean-up-your-hard-drive-8-0-1. A typo maybe?
Google chrome installation file for mac. 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.
| Click here to return to the 'Create 'ledger paper' in Excel' hint |
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. 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! Mac disk download.
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.
https://bestmfile884.weebly.com/casino-online-free-movie.html. 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.
I usually just select the area that I want every other line shaded. Then use excel's Format -> AutoFormat -> List 1 2 or 3. 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.
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 <b>and</b> 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. <b>But</b> 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
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.
0 
Star