Global Changes across multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top