Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. Note: to keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column. Unfreeze Panes. To unlock all rows and columns, execute the following steps. On the View tab, in the Window group, click Freeze Panes. Let's add our own message at the top of the list that stays visible. The first thing we'll do is convert our list into an Excel table. This will make it easier to count the rows in the list. Note that Excel automatically names all tables. We'll rename this table 'Properties', to make the name more meaningful.
Using Conditional Formatting command can shade every other row or column in a selection of Microsoft Excel. Step 1: Select the range in which you will shade every other column. Step 2: After clicking the Home Conditional Formatting New rules, it shows the New Formatting Rule dialog box.
Step 3: In New Formatting Rule dialog box, Select the Use a formula to determine which cells to format item in the Select a Rule Type section. See screen shot (Fig. Step 4: Enter =MOD(COLUMN,2) in the Format values where this formula is true: box. See the following screenshot: Step 5: After clicking the Format button in the New Formatting Rule dialog box, it displays Format Cells dialog box.
Step 6: In the Format Cells dialog box, select one background color, and click OK button to save settings. See screen shot: Then every other column in the selection is shaded with selected background color. Shade every other column in Excel with Kutools for Excel If you have installed, its Alternate Row/Column Shading tool can help you shade every other column or row quickly and conveniently. Includes more than 300 handy Excel tools.
Free to try with no limitation in 30 days. Step 1: Select the range in which you will shade every other column. Step 2: Click the Kutools Format Tools Alternate Row/Column Shading.
See screen shot: Step 3: In Alternate Row / Column Shading dialog box, check Columns option and enter 1 in Shade Every box, and Click OK. See screen shot: Then every other column in the selection is shaded with preset color.
Note: The Alternate Row Shading tool presets shade color, and user can customize the shade color in the Alternate Row / Column Shading dialog box. 's Alternate Row/column Shading tool can quickly apply shading to alternate rows or columns for a range cells in a worksheet from using the Conditional Formatting and standard formatting to improve the readability of your worksheet in Excel. Relative articles:. Increase your productivity in 5 minutes.
Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:. Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.