Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 14:30:23 +0000
Post From: Use Excel for spreadsheet
| [2017-09-17 06:08:40] |
| toews&kane - Posts: 209 |
|
I think for me it's a couple of annoyances. 1. I can't highlight cells in bulk, meaning if I try to take a column and do a highlight I have to select a smaller range and go > right click> cell properties. The three clicks are fine for me but just not able to highlight an entire column/row 2. Freeze panes - if I try to freeze columns it only would let me go as far as to column M. You may think why would this guy want to freeze panes further than M there's no screen space but, I guess this one is just a minor annoyance, maybe on a scale of 10 i say 5/10. Generally it's the aesthetics part of it to make it easier for me to sift through and analyze the numbers with the highlight and freeze panes. One other thing that we can improve on is when I do data sorting. Sometimes I play around with the data sorting and A through J is pretty good, if I do a sort that will bring the headers to the bottom it automatically regenerates it at the top. But it doesn't do that from AA onwards. It's just a annoyance if I do a mistake on the data sort on the sheet I generally have to start over, there's no undo. 3. One thing that I really hated for years is if I add any studies to the chart after I've added the spreadsheet study the headers will be shifted and misaligned, if I have added a column for some calculations in the back. ( I guess I should use K through Z) and I guess pumping the data through to excel wouldn't help this. I am using excel 2016 btw. Cheers, W |