Global Changes across multiple worksheets

  • Thread starter Stephanie Fallon
  • Start date
S

Stephanie Fallon

Dear All,

I have multiple worksheets which I need to round out the decimals and not show zero in those accounts that display them. All the rows match across the board. How can I do this globally not going sheet by sheet?

Thanks,
Stephanie
 
M

Michael J. Malinsky

Right-click a worksheet tab and select "Select All Sheets." Then highlight
the rows you want to format and the changes should carry to all sheets.
Just remember to Ungroup Sheets after you're done or other changes you make
to one sheet will also carry over (including data input) to the other
grouped sheets.

HTH


--
Michael J. Malinsky


Stephanie Fallon said:
Dear All,

I have multiple worksheets which I need to round out the decimals and not
Click to expand...
show zero in those accounts that display them. All the rows match across
the board. How can I do this globally not going sheet by sheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracked changes by multiple people modified to one 0
Embed the same Excel multiple times 0
Editing an "IF" function across a worksheet/excel file 2
Average across worksheets ignoring zero 2
How to get range names to Apply across multiple tabs 1
Multiple VLOOKUP in an IF statement 2
Linking Totals Across Multiple Worksheets 3
How to modify and updte specific styles for specific paragraphs across the document 0

Top