Bug? Arrow keys skip rows when merged and grouped
I have a sheet for cost calculation in complex projects.
There are ten - fifteen columns, starting with item description, and initial cost, followed by different additions for freights, banking fees, contingency etc in percentages, then summing the costs
before having next column state margin followed by columns for end price.
To make it easier for controllers, I added one row per item, where I put the calculated the actual value of the percentages and margins, and also distribute accurate allocation for cost centres.
A few columns are merged for readibility; the item description
and a couple of sum-summaries and also the end price.
To facilitate handling during calculation, the rows are grouped two by two, both for readibility and eliminate unintentional changes to the formulas (I can't protect the sheet as adding/removing rows are done frequently),
The thing is, when having the groups contracted, that when moving about the sheet with the arrow keys, Excel skips one row when going up, bot not down through the sheet.
For instance, I change the base cost at G46 and going for G44 (merged and grouped so
they are adjacent to each other) to change the cost for the previous item, but after one press of the up arrow, I land at G42 - it skips one visible row.
This problem is only for the merged cells, and when having them expanded it works as expected - and also moving down works fine, it is only when moving upwards.
Note that I have "Summary rows below detail" under Outline unchecked, as the grouping is related to headers and not to summarys.
I have put a lot of work in this sheet, automaticly calculating currencies by exchange rates and summing per product lines, and the grouping is imperative to getting a good overview since our projects gladely needs a few hundred entries.
The problem is recreated and can be experienced in this excel file:
http://thelord.se/Mobil/Excel_row_skipping.xlsx
Try moving from C4 to C11, no problem, but move back up and you see how it jumps two rows at a time.
Please advise if this is a bug that can be fixed by a hotfix, or if there is any reasonable way to get around this.
I'd hate to be forced to un-merge the cells as it would affect a few formulas that collects the values per row.
I'm also not totally against
the idea that I might be doing something wrong,
Thank you for your time, and best regards
Kristoffer Lord, Sweden.
Solutions to the Problem Bug? Arrow keys skip rows when merged and grouped
Download SmartPCFixer to Fix It (Free)
OK, I see what you mean now.
The answer is to not use merged cells. They are a well known cause of issues for many things in Excel.
Alternatives are:
a) putting the values ABCD in the first row only (so in your file, cells C5, C7, C9 and C11 would contain A, B, C & D, but cells C6, C8, C10 and C12 would be blank),
or
b) putting the values ABCD in every row
If you do (a) above, you can use cell borders to make the cells appear
merged. You can do that automatically with Conditional Formatting:
Select cells C5:C12. Unmerge them, then do Home tab > Conditional Formatting > New Rule > Format only cells that contain > Format only cells with: Blanks > Format > Borders tab...
then apply only Left and Right borders using the buttons at the bottom of
the large white box. OK, OK.
Repeat the CF: Home tab > Conditional Formatting > New Rule > Format only cells that contain > Format only cells with:
No Blanks > Format > Borders tab...
then apply only Left and Right
AND TOP borders. OK, OK.
Apply borders to all sides of the other cells using All Borders in the Home tab > Font group > Borders.
Now do View tab > Show/Hide group > Gridlines (uncheck).
Hope that helps.
Cheers
Rich
Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.
Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.
Another Safe way to Fix the Problem: Bug? Arrow keys skip rows when merged and grouped:
How to Fix Bug? Arrow keys skip rows when merged and grouped with SmartPCFixer?
1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.
2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.
Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.2.2.0.0 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.2.2.3.0 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.2.0.6.22 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.1.1.88.1 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: [Solved] BOSD and now BOOTMGR is missing,Tech Support: bsod when connecting ipad to adhoc wireless network,How to Fix Problem - BSOD, No windows updates, solutions given - do not load or work, missing or corrupt files please help?,How Can I Fix - Bluetooth problem after win 8.1 update?,[Solution] booting from external hard drive's backup,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work
No comments:
Post a Comment