![]() ![]() ![]() Excel Training Courses are available at. Click the Formats from the Paste Special box.īask in the glory that is the alternate rows, easy to see and a lot less headaches when in comes to reading loads and loads of data.Click the Paste drop down list then press Paste Special.Hold down the Ctrl & Shift keys then tap the down arrow.Copy the selection by holding control and pressing C.Select range that you want to remove shading from. Highlight both the row you have just changed the colour of and the row above it. Example: remove conditional formatting shading and background color from selected range in Excel.Now you can remove the filter from the Data menu (Turn off filter). Open the Conditional Formatting dialogue box (Home> Conditional Formatting> New Rule) Keyboard Shortcut Alt + O + D. Highlight the second row of the table and change the background colour to one of your choice, I changed my to a light blue. Now select the rows 6, 10, 14 and 18 and right click and delete the rows. To select every other row for highlighting, click on the cell (usually with column headers) where you want to start formatting, then hold down the Ctrl key and click on the cells of every other row (lightbulb cells) that you want to include in your formatting. Here are the steps to highlight every alternate row in Excel: Select the data set (B4:D15 in this case).Formatting every other row Excel version (2007 – 2016) Go to Home and, select the arrow next to Text Highlight Color. It’s obvious from that very description that someone did not go through that process but found an alternative way of colouring the alternate roww. Windows macOS Highlight selected text Select the text that you want to highlight. Now if you’re thinking that they have manually highlighted every other row taking literally ages to go through a mind numbing process that could take hours. You can also right-click the mouse and select. That will delete the selected third, fifth and seventh rows. One of the features you particularly notice is the alternative row colours. Hold down the Ctrl key and then press the key. You’ve seen your work colleagues spreadsheets and they simply look fantastic. ![]()
0 Comments
Leave a Reply. |