#1
|
|||
|
|||
Data not completely shifting in Excel 2016
I know this is a silly tech question, but Excel is not my thing. Does anyone know how to keep the info in a row in Excel grouped so even when a new row is inserted, the info stays together? The info from a few of my columns shifts down, but some does not. Help Even if I click on the 'row' and highlight the whole thing, the info still does not completely shift. |
#2
|
||||
|
||||
Are the check boxes created/managed by a macro?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I didn't know how to do that So I copy/pasted the boxes. I'm sure that's where the problem lies - but there should be a way around it, wouldn't you think?
I could also delete them all and start over if there's a way to do it better? SO out of my depth. |
#4
|
||||
|
||||
When you right click on a checkbox a menu appears. Select Format control
In the properties tab check "Move and size with cells" or Move and don't size with cells". Click OK and try again ( do the same for all boxes if it works)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
It didn't work I just deleted all of the check boxes and made the columns drop down menus to simply things.
Thank you for trying! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2016 line chart shows 2 erroneous (zero) data points in x axis. How to remove them? | 5434aw | Excel | 4 | 07-31-2016 07:54 AM |
Filtering data no longer defaults to search box Office 2016 Mac | BagpussLondon | Excel | 0 | 10-12-2015 10:07 AM |
Excel or Access Shifting data | Aarotech | Excel | 1 | 01-27-2013 06:43 AM |
Shifting events in Outlook? HELP! | gookies | Outlook | 1 | 05-25-2012 07:18 PM |
Help with forms (shifting focus) | jrh312 | Word | 0 | 11-19-2009 12:59 PM |