Saejosxjmpu

Sheet Naming Rules in Excel When renaming a sheet in Excel, there are some naming rules you need to follow A sheet name can be a maximum of 31 characters in length You can not leave a sheet name blank You can not have two sheets of the same name You can not begin or end the sheet name with an apostrophe (')Step 6 Copy cell B2 and paste it into cell Cell will now show the word "Screwdriver" This is because the relative reference in the formula you entered is now pulling the name of the worksheet from cell A3 rather than Tip The INDIRECT () function is a flexible tool that allows you to substitute the contents of a given cell into aExcel formula to get sheet name from a cell Microsoft Excel Details Excel formula to get sheet name from a cell I am trying to use a formula to reference a worksheet by getting the sheet name from a cell as shown below =IF (A34="","",MAX (Client10!C$3C$33)) I have about 50 sheets and want to sect the sheet depending on the row