Protected workbook, filtering data and going to the first blank line

dapper1960

New Member
Joined
Feb 23, 2016
Messages
2
HI - I have no idea what I am doing and just usually use the general excel functions. So please bare with me.

I currently made 2 buttons in my spreadsheet. 1 to go to the first row of data and the next to go to the end or blank row - both in column A. The book isn't that big (only 400 lines). I had to protect it because people were entering data in row 700 or something. I do have a formula in column P that does go down to row 699 and that particular column is protected.

Now the big complaint is that they have to "page" thru all that data to find what they are looking for. If I sort while it is protected, excel crashes .

So I made extra buttons to filter for them but the blank row is hidden, i can't get to it.It seems like all I can do is either go to the next blank line or filter by their name. I don't know how to have it display so they can enter data. Can I do that? utilize both functions? And if Yes, how?
OR should I have a delete blank rows button ?

Thanks in advance for all your help
Just a little admin trying to make someones day easier.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,329
Members
414,055
Latest member
mcarduner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top