ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change sheet tab name and color (https://www.excelbanter.com/excel-discussion-misc-queries/223484-change-sheet-tab-name-color.html)

Gene Augustin

Change sheet tab name and color
 
I have a workbook with only one sheet. I want to change the name of that
sheet to "QIF" and its color to RED and add a second worksheet with "IIF"
name and color Yellow.

Gene Augustin


Shane Devenshire

Change sheet tab name and color
 
Hi,

change a sheet name - double-click the sheet tab and type in the new name
change the tab color - right click the tab and choose Tab Color
add a new sheet - press Shift+F11

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Gene Augustin" wrote:

I have a workbook with only one sheet. I want to change the name of that
sheet to "QIF" and its color to RED and add a second worksheet with "IIF"
name and color Yellow.

Gene Augustin




All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com