Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Where do I get a Spread Sheet to do the following?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Slydude" data-source="post: 1761042" data-attributes="member: 131855"><p>If you select a block of cells and then apply the change it will be applied to all of the cells that are selected. You won't have to change them one by one.</p><p></p><p>Try the following if it does not work you can always revert to your current file. First save a copy of your current file with a slightly different name. This new file can be used for the experiment and preserves the work already done since you are working on a copy of the file. Now do the following:</p><p>1. With one of the files open choose<strong> Edit>Select</strong> All (Command A).</p><p>2. Go to <strong>Format>Cells </strong>and apply the Currency formatting just as you did before. </p><p></p><p>This applies currency formatting to All cells. It shouldn't affect the cells that only have text in them though such as the column headings. If it does simply close the file without saving the changes. </p><p></p><p>If the method above does not work you can select the cells in each column that need the format change and apply the change that way. You don't need to do it cell by cell. I should have made that clearer in my post above.</p></blockquote><p></p>
[QUOTE="Slydude, post: 1761042, member: 131855"] If you select a block of cells and then apply the change it will be applied to all of the cells that are selected. You won't have to change them one by one. Try the following if it does not work you can always revert to your current file. First save a copy of your current file with a slightly different name. This new file can be used for the experiment and preserves the work already done since you are working on a copy of the file. Now do the following: 1. With one of the files open choose[B] Edit>Select[/B] All (Command A). 2. Go to [B]Format>Cells [/B]and apply the Currency formatting just as you did before. This applies currency formatting to All cells. It shouldn't affect the cells that only have text in them though such as the column headings. If it does simply close the file without saving the changes. If the method above does not work you can select the cells in each column that need the format change and apply the change that way. You don't need to do it cell by cell. I should have made that clearer in my post above. [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Where do I get a Spread Sheet to do the following?
Top