Solved

Excel Spreadsheet that the misisng row numbers

Posted on 2016-07-19
5
52 Views
Last Modified: 2016-07-20
I have a spreadsheet that has some missing row numbers, It try to highlight the rows and select unhide. But nothing change.  What else can I do to change that ?

Missing Row number
0
Comment
Question by:tommym121
5 Comments
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 125 total points
Comment Utility
You have Autofilter activated. Either unfilter the list or disable the autofilter.
1
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 250 total points
Comment Utility
try go to Data tab, and uncheck Filter?

or go to Data tab, beside the Filter, click the Clear?
1
 
LVL 28

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 125 total points
Comment Utility
Or in short, press Ctrl+Shift+L to show disable the filter.
1
 

Author Closing Comment

by:tommym121
Comment Utility
Thank you very much
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
Comment Utility
You're welcome. Glad we could help.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now