Auto un hide rows when click tab bottom or put cursor to write

Osama Fawzy

New Member
Joined
Aug 24, 2022
Messages
39
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
Hi, i have a table consists of more than 1000 rows, it's formatted and has some functions, i want to appear just the row which i prepare to write and the others are hidden and so

00053408-Nov-202200:00031293:311316229414:4110004:04540913613
00053508-Nov-202201:32131295:031316329416:1310005:36541013614
00053608-Nov-202200:53131295:561316429417:0610006:29541113615
00053709-Nov-202201:46131297:421316529418:5210008:15541213616
00053809-Nov-202201:43131299:251316629420:3510009:58541313617
00053909-Nov-202202:30131301:551316729423:0510012:28541413618
00054009-Nov-202201:43131303:381316829424:4810014:11541513619
00054110-Nov-202201:51131305:291316929426:3910016:02541613620
00054210-Nov-202203:15131308:441317029429:5410019:17541713621
00054310-Nov-202204:09131312:531317129434:0310023:26541813622
00054410-Nov-202200:56131313:491317229434:5910024:22541913623
00054510-Nov-202205:00131318:491317329439:5910029:22542013624
0005460
0005470
0005480
0005490
0005500
0005510
0005520
0005530
0005540
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You said:
Hi, i have a table consists of more than 1000 rows
If this an actual Excel Table, I need the sheet name and the Table name
Or do you mean you have a worksheet
 
Upvote 0

Forum statistics

Threads
1,215,065
Messages
6,122,944
Members
449,095
Latest member
nmaske

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
Back
Top