terewdx.blogg.se - How to unhide first column in excel 2010

#How to unhide first column in excel 2010 how to#
#How to unhide first column in excel 2010 serial numbers#

The second argument, $B$2:B2, is simply the range of cells you want to count. The first argument, 3, instructs Excel to count the numbers in the range. Select the first cell to which you’d like to assign a number and then enter the following formula:.This situation can confuse and complicate data analysis.Įven if you’ve filtered your data, you can still add row numbering to your sheet.

When presenting data, filtering enables you to share just what your audience needs without throwing too much information all at once. Only the unfiltered rows will be shown onscreen at any given time. It will enable you to select certain parts of your worksheet and have Excel show only those cells.įor example, if you have lots of repetitive data, you can easily filter out all of those rows and leave just what’s you need.

#How to unhide first column in excel 2010 how to#

Get a spreadsheet with hidden columns Here's how to unhide columns in excel. The filter is a function that allows you to sift (or slice) your data based on criteria. A quick tutorial showing how to hide and unhide columns in excel spreadsheets. How to Auto Number Filtered Rows in Excel

#How to unhide first column in excel 2010 serial numbers#

At this point, enter the step value (“1” by default) and then enter the stop value in the spaces provided.Įt voila! All the cells in the selected column will now have unique and sequential serial numbers for easy identification.

In the dialog box, select ‘Columns’ from the ‘Series in’ section.

This should open a floating dialog box in the middle of your sheet.

Click on “Fill” and then select “Series” from the dropdown menu.

Click on “Home” at the top of your sheet.

Enter the first value, say 10, in the first cell.

Select the first cell to which you’d like to assign a number.

Here’s how to autofill row numbers in Excel using the fill series function: In this situation, the fill series feature will autofill 10 rows in the selected column, starting with “1” in the first cell, “2” in the second cell, through “10” in the last cell.

For example, let’s say your start, step, and stop values are 1, 1, and 10, respectively.