This is a fun and quick poll.
I want to know what is the maximum number of cells you can see when you open Excel. Do this:
- Open Excel, Maximize the window if it is not.
- Just tell me the bottom right cell that you can see completely.
- Go have a good weekend 🙂
PS: Make sure you set the zoom to 100%.
I will go first. I have 2 monitors.
On the large 24″ monitor, I see cell AC40 and on the 16″ laptop monitor I see S26.
What about you?
Just post the cell address in comments.
Check out previous polls.
PS: I am planning to use the poll data to make a visualization on how many cells you can see. So please respond.
330 Responses to “What is the last visible cell in your excel window? [Poll]”
U39 (laptop screen)
S25 (Laptop Screen)
S48, or O63 depending on my VDU. (desktop)
S49 (and part of T50) on my monitor at work and most of V44 on my laptop monitor (also at work).
S26. 14" Lenovo Laptop
Screen resolution 1280x1024.
S45 on my normal monitor at work.
AM47 if I expand it across both monitors.
I use Excel 2007. Without minimizing the ribbon I see Z40 and after minimizing the ribbon I see Z44. Desktop - 22" wide screen.
S30 with the Ribbon minimized
D6, but I guess I should change my zoom setting down from 400. Wait, that's better...at a zoom of 10% I can see much much much much much more: FJ262.I hope this visualization of yours is going to have a log scale, Chandoo.
Otherwise, put me down for 025, or O30 if I minimize the ribbon.
X42 on my 17.3" laptop screen, X51 on my external monitor 20" both widescreen
and on my wifes laptop
S27 15.4" laptop
AG59 (23" widescreen)
S51 - desktop; Excel 2003
Working with Excel 2007
Y39 on 22" LG Monitor at work.
Y44 with Ribbon minimized.
to make a comparison everyone should have the same dimensions for the cells. It's ok to take the new sheet, but with the same Font. I have Verdana 11
AC 43 on a widescreen desktop. AC 47 with ribbon mimised. Standard row height and default Calibri 11pt
Microsoft Office Excel 2003 (11.8302.8221) SP3
1024 x 768 Resolution
S27 with ribbon and S32 with ribbon minimised on LENOVO laptop.
Curious to see the visualisation with such a diverse range of data.
S32 (on laptop) - my font is by default Calibri 10
On laptop with 1280 x 800 px resolution
xl 2010: Q25
xl 2003: Q32
gotta check back at work for secondary 22" monitor. will be significantly different.
oh, and with ribbon minimised and formula bar reduced to 1 row (which I don't like in xl 2010: I have the formula bar to at least 3 rows so I can do long formulas and actually see them when the cell is selected -- so, anyway, without the fluff:)
U30 (Excel 2007) for 1440*900 resolution on 15" monitor
S43 on laptop running on an old Elonex monitor at work.
Excel 2007, Ribbon maximised, one row formula bar.
Monitor is 1920*1080.
I see cell AC40.
How to change default zoom in excel (quick tip)
1. Open a new workbook .
2. Change zoom
3. File>Save As a template file (xlt, xltx or xltm) in your XLSTART folder
Excel 2007 Template (xltx)
Excel 2007 Macro-Enabled Template (xltm)
Excel 97-2003 Template (xlt)
S27 on my laptop screen, V33 on external monitor
U32 (laptop screen)
i see O47
V34 using my default Office 2007 formatting.
With the ribbon on and one row on the formula bar
With Arial 8 font (changes the number of rows)
At work (Excel 2007):
Ribbon Maximized Q29
Ribbon Minimized Q33
19" monitor, Ribbon maximized, formula bar x 3 rows and QAT below Ribbon
S25 - laptop screen
Somewhat impressive when you think about it...that's 836 different cells to work with!
V32 - laptop connected to monitor, 2007
S 28 (Laptop)
19 inch with the ribbon minimized.
M24, 1024 x 768, excel 03
S41 on one screen.
S32 on the other.
Excel 2007 - laptop S27 and monitor U32
Looks like I need a bigger monitor based on the monitor size others are showing!
S 38, Is there a way to change that?
28" lcd @ 1920x1200
ac63 in 2003
ac48 in 2010 w ribbon
ac53 in 2010 w/o ribbon
Q29 on DELL 16"TFT - Excel 2007
Laptop, XL 2003: U41
Laptop, XL 2007: U39
v49 - laptop with desk monitor
X37 on 17" Laptop Screen
AC48 in Excel 2007 w ribbon
I think the video resolution determines the cell. Like garyk, I also have a 1920x1200 monitor.
U25 on my lappy if I'm running (yuck) windowz in 07.
W30 when I'm running 07 in WINE.
S37, I usually have the formula area expanded. If it's not expanded, S38.
S40 on my 4/3 17" screen.
Y38 on the 16/9 21" screen. these are with 2007 and normal ribbon.
19" Monitor 4:3 Aspect Ratio
Resolution: 1024 X 768
30 inch Apple Cinema Display (connected to a PC)
2560 x 1600
Dell Desktop, 21" widescreen monitor 1920 x 1080 resolution:
Excel 2010 AB43, ribbon minimized AB47 (2nd monitor)
Excel 2007 AC40, ribbon minimized AC45 (1st monitor)
Excel 2003 AC52
15" MacBook Pro:
Excel 2011 U38, ribbon minimized U43
Excel 2008 R46
V39 on a 22" widescreen monitor @ 1680x1050 resolution, ribbon minimized
T25, on 13" laptop, Excel 2010
Maximized @ 100% on two 19" monitors; AM39
Effective Resolution of 2560 X 2048
AS41 on 2 monitors effective size 1024 x 2960
A few quick measurements on my windows 7 machine with excel 2010
Left = 26 pixels
Right = 16 pixels
Minimised ribon = 94
Normal Ribon = 184
bottom status bar = 37
Windows 7 Task Bar = 41
Should enable interpolation on similar systems
S48 & P48 (2 screens)
At work (last full cell):
Main monitor: Y39
Secondary monitor: S39
Expanded across both: AS39
Hope all is going well Chandoo..
O27 at work. Using a 19" monitor and Excel 2003
(RES 1440*900 with a 17" Widescreen Monitor)
Have a great weekend !
Q45 Mac / numbers
S46 (Office PC)
S47 17" screen
V32 - HP LA1905
Cell U44 with zoom level at 100%, I can partially see V45.
O51 on Excel 2007 with the CRT set up in portrait mode.
T35 on my Laptop
22inch monitor. Excel 2003. See half of Z48
Y38 (external screen - 21")
U33 (laptop screen)
17 in monitor, Excel 2003 - O27
T32 on my work computer, using Excel 2003.
Z51 at a default of Arial 11 point font. (Changing the either the font or the font size changes the number of visible rows.)
AC39 - HP L1908wm / Zoom @ 75%
S27 on my laptop
S40 on my Desktop
I can see V30 on 19 Viewsonic display...... have a good weekend!
S44 (monitor) and S35 (laptop)
S36 on a 19" Dell with default cell sizes
20.1'' Desktop Screen: AQ74
U46 MacBookPro - 11" width, 13" diagonal
it wasn't 100% It was 60%
now it is 100%
it is Y44
Z40 22 inches display resolution 1680*1050
O31, but that's with a lot of toolbars open. Excel 2003
I have 2 laptops: 1.) 17" T31 2.) 15" T25 - on 100%.
S27 on my laptop.
Y41 on my widescreen monitor.
Love your work Chandoo. You are awesome.
AC41 @ 100% Zoom
Excel 2003, IBM T43 laptop
Y38 (desktop at work)
DELL DESK TOP
L45 : 19 inch monitor
AC57 (24" screen) with zoom level at 100%
Embarrassing 15 inch monitor O26.
BK99 (laptop), but rather difficult to read ....
S48, XL2003, 1280 x 1024
I see AL 73
In Excel 2007, S37, but S41 if I minimize or hide the Ribbon, and S42 if I minimize the Ribbon AND my Quick Access Toolbar. ~mp
well, if you want to include spanning, across my 3 monitors i see ck61.
S35 on a 19" Monitor.
S48 on single monitor, AM47 stretched across dual monitors
That's Excel 2003, on 2 17" monitors, both with screen res at 1280x1024
T25 on a HP probook 4410s laptop
N27 on my laptop running Excel 2010
Q42 on my trusty 19" CRT on the PC running Excel 2000
AC51 (22" Work)
S45 on my 19" Gateway and V40 on my 19" Lenovo widescreen.
T25 (Excel 2007) Laptop
T38 with laptop in docking station 22" monitor
U46 on 1280x1024 resolution
ouch L25, excel 2007, waiting to hear some tips about how te see more.
Resolution 1600x1200 on Viewsonic 2130b
S28 15.6 laptop
15,4" Lenovo Notebook
Excel 2010 beta w/o ribbons
S60 - 20 inch IMAC
BR80 - Excel 2010
2 x 30" Apple Cinema Display 5120 x 1600 (WinTel)
different cells with different font size:
Ariel 8 --> O41
Ariel 10--> O36
Ariel 12--> 031
This is Dell laptop "inspiron 640m"
two screens S38 on one, S39 on the other...
On my work laptop screen: S27 (1280x800)
On my second monitor: X49 (1600x1200)
Note that there is no taskbar on the secondary screen (probably a row's worth), and if you minimize the ribbon you can gain another 4 rows. I'd have to check the screens I have at home.
A 113 comments for this post!
Way to go dude - way to go!
Congrats! you have them eating from your hands.
V54, home computer screen. However, I made my default font calibri in size 8, to increase visible cells.
U33 - laptop
S37 Normally (19" 4:3 LCD)
S44 Taskbar and Ribbon minimized
S37 - Work computer.
M46 using Office 7
S24 - Laptop
AC64...HP 25.5" Arial 8
AC40 27" 1920x1080 res
AD55, 25/5" 1920x1200 res, my default zoom is 85%
🙂 seems a busy post..
with ribbon minimized on Excel 2007
i have opened 2 Workbook
In first i got O46
In Second i got K34
Have 2 22" screens
S34 - Toshiba La[top
N31 . . . but I use a default column width of 12.
A1. 🙂 Just kidding. X34. I have a 1600x900 17" monitor on my laptop. Screen res is set to max.
S27 on a 13.3" screen at 1280x800 resolution
AC41 --- 24" monitor and using excel 2007
S31, Lenovo X201 laptop screen, Excel 2010
T24 Acer 16"
P19 - laptop
025,on a 12' Dell Laptop
V41 om dell D620 work laptop, Excel 2003, 1440 x 900 res
S39, but with Excel across my dual monitors I can see AM39.
Wow... this is the biggest thread ever and the responses are still coming. Thank you 🙂
dell u 2410 (x2)
if i use both monitors it would be ba63....
(ba69 without ribbon)
do i win sth now?
S38 at home using Excel 2007.
Will check work PC (Excel 2003) on Monday.
S26 on HP 6530s laptop
Good luck tabulating all the data!
with / without Ribbon. XL 2007, default resolution, Calibri 11pt.
W40 / W44 Desktop screen 1, 1680 X 1050 eizo S2110W
R84 / R89 Desktop screen 2 1920 X 1200 HP L2475W Portrait mode (my default for this screen)
AC49/ AC53 Desktop screen 2 1920 X 1200 HP L2475W in Landscape mode
W49 / W54 Dell Vostro 1700 laptop 1920 X 1200
W30 I'm using a Vaio laptop, about a 17" HD monitor. Chandoo, what an interesting clever Poll.
t40, 16'' Monitor
Samsung 22" (1680x1050): Y42
Projector (1920x1080): AC45 (AC46 is fully visible but not the bottom border)
doesn't column width and row height of excel file open make a big difference in survey results....if all had columns width at 10 and row height of 15, then results would be more relevant
S40 19" monitor
O25 with Excel 2007 on IBM X41 laptop
2048 X 1152
QAT below ribbon
status bar and formula bar visible
Windows taskbar hidden
V32 on a HP 19" monitor
AL80 or AL85 (with or without ribbon) - Excel 2011 on a 27" iMac. Font is the standard Calibri 12, zoom at 100%.
AM90 if I choose Full Screen Mode.
The screen cell size depends on the Pixel size of the screen and the default Font and Font Size
Using the Standard Calibri 10 Font of Excel 2010 at 100% I get AC53
At Arial 6 point 100% Zoom I get AM90
W43 with default settings in Office 2010, 23 inch full HD monitor
Q39, 17", 1152x864 px
U31, 11.6", 1366 x 768, Excel 2003
R26, 1280 x 800
Excel 2003: S33
Excel 2007: S32
Both have same default settings - font: Arial 10; column: 8.43; row:12.75
laptop: Dell D630
AC47, 1920 x 1280, Excel 2007
Work computer running Excel 2000
3 rows of toolbars at the moment
Laptop screen (Dell Latitude D630) with 1280 x 800 pixels = Cell V31
Additional monitor (Dell 2007FP) with 1600 x 1200 pixels = Cell AA59
AC59 full, AC60 about 4/5ths of its height. 24" HP monitor LP2465.
I also replied to your email. oops it has been a long weekend...
x37 on 20" monitor
(24 inch screen - I have font size set to 8 point Arial)
Microsoft Office Excel 2007 O25
Dell 17? Monitor
(Arial 10 and 100%)
S27 and in minimised ribbon S31
O25 (Excel 2007)
Desktop screen Q38
Z38, have fun analysing... 🙂
S45 on my 19" work monitor.
O33, on laptop 1024x768 px
17" Screenresolution 1600x900
Font Calabri 11
With ribbon X33
V33 on laptop 14" resolution 1440 x 900
ACER V223W monitor - cell Y38
ACER AL1916W - cell U32
(normal monitor at work)
U25 (14" Laptop)
O28 Primary monitor
O32 Secondary monitor
S34 with the ribbon minimised
S32 Excel 2007
and R40 with the ribbon minimized
P51 - Desktop 17" Monitor, Excel 2003, Taskbar hidden.
Q47 Excel 2007
Z48 - Desktop computer with Excel 2003
S27, laptop screen
S46 on one 1280x960 display, AM46 stretched across two identical displays.
S27 on a laptop screen
S33 on desktop
u41, Excel 2011 on MacBook Pro
U25; with ribbon open
(100% zoom level)
S45 on my normal monitor at work with the ribbon in Excel 2007
Excel 2007 - 22" desktop monitor @ 1280 x 1024 S45
[...] weeks back I ran a poll asking you to tell me what is the last visible cell in your excel window. It was a casual poll. So I didnt expect a lot of responses. But, boy I was wrong! 295 of you have [...]
2 x 22 inch monitors 🙂
AD42 100% view
W40 on monitor 1
S32 on monitor 2
S34 1440 X 900 on 17" widescreen w/Ribbon off and Google sidebar on
it is S25
It is AC41
AC47 16" full HD laptop
S34 (Without Scrolling) , 100% Zoom, HP Laptop (14").
X50 - 27" widescreen
O31 - Laptop
AC58 wide-screen laptop - Excel 2003
SAMSUNG SynchMaster 930B (19"):
normal ribbon: S37 (S38*)
minimized ribbon: S42 (S43*)
* Quick Access Tool-bar above
Late to the party, but here is some data FWIW
x61T laptop screen at 1400x1050: U44
Dell 2005FPW 20.1" LCD at 1680x1050: Y45
[...] 31 posts had more than 50 comments each. The maximum comments were 313 on the last visible cell poll. [...]
Even later to the party.
T39 - on a single SyncMaster 920N (1280x1024)
AM40 - if stretched over two SyncMaster 920N's (1280x1024)
AC42 on my primary screen
V32 on my secondary
AC41, just installed a 24"Asus 🙂
U34 on laptop
hp 500, S33
s27, sony vaio
Excel 2010 on 2x Dell P2411H monitors (1920x1080 ea)
Effective res 3840x1080
According to me we can see IV65536 number of cell....for that we have to reduce cell & Column size to 1 pixel n zooming size to 10% ( but which is very difficult to see the cells (i.e IV65536 cells)
The last cell I see using an iMac 21.5' is AC 70