lasasadmin.blogg.se

1. #Why is conditional formatting excel 2016 grayed out how to#
2. #Why is conditional formatting excel 2016 grayed out for mac#

#Why is conditional formatting excel 2016 grayed out how to#

How To Create Basic Formulas In Microsoft Excel.Microsoft Word Formatting Features such as Subscript.How To Create A Vlookup Function In Excel.Using Microsoft Excel To Split Data Into Separate Cells.Adding Multiple Photos To PowerPoint By Using Photo Album.Make A Word document Into A PowerPoint Presentation.How To Fix PowerPoint Presentation Layouts.Naming Cells in Formulas and Functions of Excel.In our training sessions you are welcomed to bring examples of your work to class. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. Microsoft Office Small Group Training SessionsĪZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. Try the video below to help you when navigating multiple sheets. This usually clears out any underlying issues. Solutions:Ĭopy paste the problem sheet to a new workbook.

#Why is conditional formatting excel 2016 grayed out for mac#

If Custom view is greyed out and I have no tables or sheets that are grouped.įormat Table for Mac users is a little different follow this link to help you out. You will see in the Ribbon a Table Tools tab select Design and press Convert to Range. If that hasn’t solved your problem perhaps you have Tables active. To turn off Format Table. How to ungroup sheets, Right click on a sheet and Select Ungroup sheets. It could be you have sheets grouped or you have Format as table activated. Now – Follow the steps in Option 1 and name it Grand Totals.Now – Follow the steps in Option 1 and name it Quarter.Change any print setting – margins, page orientation.Custom ViewĬustom view is a very useful tool when you find yourself changing the setting for printing your spread sheet, needing to change the page orientation, margins, page orientation, setting print area. When you use added features like a graph, Pivot Table, Table or Slicers you will notice an extra tab in the Ribbon specific to this task and at times you may be disabled from using one feature while another is turned on. If you press Ctrl Enter you will exit the mode but stay in the same cell ready to preform your formatting. That is if you can see your cursor flashing in the cell next to the text or number you entered. Items on the Ribbon become greyed out when you are in Edit mode in a cell.