Worksheet Freeze Panes

The Bootstrap Spreadsheet implements an Excel-inspired Freeze Panes functionality. This allows end-users to lock specific rows or columns in one area to keep this area of a worksheet visible while scrolling the worksheet content vertically or horizontally.

Using the Freeze Panes command from the View tab on the ribbon, end-users can freeze arbitrary panes (lock rows and/or columns based on the selection), freeze the top row, freeze the first column and unfreeze panes.

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
EMPLOYEE ID
1
2
3
4
5
6
7
8
9
EMPLOYEE NAME
Linda Braun
Kate Smith
Nick Taylor
Oliver Hilfiger
Tommy Dickson
Andru Morris
Emmy Milton
Vanessa Mikki
Tim Bocelli
HOURLY WAGE
$10.00
$11.00
$15.00
$10.00
$20.00
$32.50
$32.00
$37.40
$29.40
TAX STATUS
1
1
2
2
3
4
2
5
3
FEDERAL ALLOWANCE (from W-4)
4
4
3
3
4
4
3
4
3
STATE TAX (percentage)
2.30%
2.45%
3.01%
2.90%
4.50%
3.12%
2.50%
3.60%
3.60%
FEDERAL INCOME TAX (percentage based on Federal Allowance)
28.00%
27.60%
27.02%
24.50%
29.04%
29.03%
28.00%
25.40%
27.40%
SOCIAL SECURITY TAX (percentage)
6.30%
6.10%
6.80%
7.90%
8.40%
3.40%
6.30%
7.90%
6.00%
MEDICARE TAX (percentage)
1.45%
1.50%
1.50%
1.33%
1.43%
2.00%
1.43%
2.60%
1.67%
TOTAL TAXES WITHHELD (percentage)
38.05%
37.65%
38.33%
36.63%
43.37%
37.55%
38.23%
39.50%
38.67%
INSURANCE DEDUCTION (dollars)
$20.00
$20.00
$22.00
$21.60
$41.40
$25.00
$19.34
$35.00
$20.00
OTHER REGULAR DEDUCTION (dollars)
$40.00
$42.00
$39.00
$40.00
$24.30
$25.00
EMPLOYEE INFORMATION
TOTAL REGULAR DEDUCTIONS (excluding taxes, dollars)
$60.00
$62.00
$61.00
$61.60
$65.70
$25.00
$44.34
$35.00
$20.00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
EMPLOYEE ID
1
2
3
4
5
6
7
8
9
EMPLOYEE NAME
Linda Braun
Kate Smith
Nick Taylor
Oliver Hilfiger
Tommy Dickson
Andru Morris
Emmy Milton
Vanessa Mikki
Tim Bocelli
HOURLY WAGE
$10.00
$11.00
$15.00
$10.00
$20.00
$32.50
$32.00
$37.40
$29.40
TAX STATUS
1
1
2
2
3
4
2
5
3
FEDERAL ALLOWANCE (from W-4)
4
4
3
3
4
4
3
4
3
STATE TAX (percentage)
2.30%
2.45%
3.01%
2.90%
4.50%
3.12%
2.50%
3.60%
3.60%
FEDERAL INCOME TAX (percentage based on Federal Allowance)
28.00%
27.60%
27.02%
24.50%
29.04%
29.03%
28.00%
25.40%
27.40%
SOCIAL SECURITY TAX (percentage)
6.30%
6.10%
6.80%
7.90%
8.40%
3.40%
6.30%
7.90%
6.00%
MEDICARE TAX (percentage)
1.45%
1.50%
1.50%
1.33%
1.43%
2.00%
1.43%
2.60%
1.67%
TOTAL TAXES WITHHELD (percentage)
38.05%
37.65%
38.33%
36.63%
43.37%
37.55%
38.23%
39.50%
38.67%
INSURANCE DEDUCTION (dollars)
$20.00
$20.00
$22.00
$21.60
$41.40
$25.00
$19.34
$35.00
$20.00
OTHER REGULAR DEDUCTION (dollars)
$40.00
$42.00
$39.00
$40.00
$24.30
$25.00
EMPLOYEE INFORMATION
EMPLOYEE ID
1
2
3
4
5
6
7
8
9
EMPLOYEE NAME
Linda Braun
Kate Smith
Nick Taylor
Oliver Hilfiger
Tommy Dickson
Andru Morris
Emmy Milton
Vanessa Mikki
Tim Bocelli
HOURLY WAGE
$10.00
$11.00
$15.00
$10.00
$20.00
$32.50
$32.00
$37.40
$29.40
TAX STATUS
1
1
2
2
3
4
2
5
3
FEDERAL ALLOWANCE (from W-4)
4
4
3
3
4
4
3
4
3
STATE TAX (percentage)
2.30%
2.45%
3.01%
2.90%
4.50%
3.12%
2.50%
3.60%
3.60%
FEDERAL INCOME TAX (percentage based on Federal Allowance)
28.00%
27.60%
27.02%
24.50%
29.04%
29.03%
28.00%
25.40%
27.40%
SOCIAL SECURITY TAX (percentage)
6.30%
6.10%
6.80%
7.90%
8.40%
3.40%
6.30%
7.90%
6.00%
MEDICARE TAX (percentage)
1.45%
1.50%
1.50%
1.33%
1.43%
2.00%
1.43%
2.60%
1.67%
TOTAL TAXES WITHHELD (percentage)
38.05%
37.65%
38.33%
36.63%
43.37%
37.55%
38.23%
39.50%
38.67%
INSURANCE DEDUCTION (dollars)
$20.00
$20.00
$22.00
$21.60
$41.40
$25.00
$19.34
$35.00
$20.00
OTHER REGULAR DEDUCTION (dollars)
$40.00
$42.00
$39.00
$40.00
$24.30
$25.00
EMPLOYEE INFORMATION
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
EMPLOYEE ID
1
2
3
4
5
6
7
8
9
EMPLOYEE NAME
Linda Braun
Kate Smith
Nick Taylor
Oliver Hilfiger
Tommy Dickson
Andru Morris
Emmy Milton
Vanessa Mikki
Tim Bocelli
HOURLY WAGE
$10.00
$11.00
$15.00
$10.00
$20.00
$32.50
$32.00
$37.40
$29.40
TAX STATUS
1
1
2
2
3
4
2
5
3
FEDERAL ALLOWANCE (from W-4)
4
4
3
3
4
4
3
4
3
STATE TAX (percentage)
2.30%
2.45%
3.01%
2.90%
4.50%
3.12%
2.50%
3.60%
3.60%
FEDERAL INCOME TAX (percentage based on Federal Allowance)
28.00%
27.60%
27.02%
24.50%
29.04%
29.03%
28.00%
25.40%
27.40%
SOCIAL SECURITY TAX (percentage)
6.30%
6.10%
6.80%
7.90%
8.40%
3.40%
6.30%
7.90%
6.00%
MEDICARE TAX (percentage)
1.45%
1.50%
1.50%
1.33%
1.43%
2.00%
1.43%
2.60%
1.67%
TOTAL TAXES WITHHELD (percentage)
38.05%
37.65%
38.33%
36.63%
43.37%
37.55%
38.23%
39.50%
38.67%
INSURANCE DEDUCTION (dollars)
$20.00
$20.00
$22.00
$21.60
$41.40
$25.00
$19.34
$35.00
$20.00
OTHER REGULAR DEDUCTION (dollars)
$40.00
$42.00
$39.00
$40.00
$24.30
$25.00
EMPLOYEE INFORMATION
TOTAL REGULAR DEDUCTIONS (excluding taxes, dollars)
$60.00
$62.00
$61.00
$61.60
$65.70
$25.00
$44.34
$35.00
$20.00
<dx:BootstrapSpreadsheet runat="server" ActiveTabIndex="1" ShowConfirmOnLosingChanges="false">
</dx:BootstrapSpreadsheet>
Screen Size
Color Themes
Demo QR Code
Calibri