Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
alexxandra pe Simpatie.ro
 | Femeie
24 ani
Timis
cauta Barbat
24 - 57 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
Let's say you have a table extending from A1 to E199, headers included.
Go to DEVELOPER tab, click INSERT and under FORM CONTROLS select Scroll Bar (bottom row, 3rd from left to right).
Insert your scroll bar where you want.
Right click it and select Format Control.
Set the current value to 1. Set the minimum value to 1.
Set the maximum value by subtracting the number of rows you want to show in the scrolling table from the total number of rows with data. Eg. if you have 198 rows of data and want to scroll each 20 rows, in the Maximum value field you write 198-20 = 178.
Incremental change remains 1 if you want to scroll 1 line at a time by clicking on the up or down arrows of the scrollbar.
Page change happens when clicking between the 2 arrows of the scrollbar. It will scroll 10 lines at a time if the value is 10.
Create a cell link in a cell outside the place where you will add your table, eg. in N1 (I will have the scrollable table in H1:L20) so N1 is ok.
Now copy your table headers to cells H1:L1.
If you don't have much data, like 100-200 you can use the OFFSET FORMULA. Otherwise see the INDEX formula OFFSET.
OFFSET FORMULA - 100-200 rows of data - simple formula, but volatile (INDEX FORMULA harder to remember, but better)
Under the header of the first column of your new table, so in H2 type the following formula:
=OFFSET(A1;$N$1;0)
Now drag it down 20 positions. Make the scrollbar the same length, so it looks nice.
Drag the 20 positions right to the last column of your scrollable table which is L and now you have a 20 row length scrollable table of your 198 rows table.
INDEX FORMULA
In H2 type the following formula:
=INDEX($A$2:$E$199;$N$1+ROWS($G$2:G2)-1;COLUMNS($G$2:G2))
and drag it down and left to your whole table.
See source for more explanations for scroll bar and formulas.
Source:
|
|
| pus acum 4 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
Added text steps.
_______________________________________
|
|
| pus acum 4 ani |
|