How to format cells to make them look more professional



0
Is there a way to apply the same formatting to every sheet in a workbook in Excel?

1 Answer(s)


0

-- You can select all the sheets in a workbook by pressing --> Right click a sheet tab --> click 'Select All Sheets' on the shortcut menu.

OR
-- Ctrl-click the tabs of the sheets that you want to group together, and the grouped tabs will all turn white.


Now format any sheet and similar formatting will be applied to all selected sheets. While sheets are grouped, anything you enter in one sheet also gets entered into the others.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password