How to format cells to make them look more professional

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

1 Answer(s)


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

-- 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.