Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2016, 07:04 AM
vmarshall vmarshall is offline Data not completely shifting in Excel 2016 Windows 10 Data not completely shifting in Excel 2016 Office 2016
Novice
Data not completely shifting in Excel 2016
 
Join Date: Sep 2016
Posts: 3
vmarshall is on a distinguished road
Question 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.
Attached Images
File Type: jpg data not shifting.JPG (43.5 KB, 12 views)
File Type: jpg data not shifting 1.jpg (42.4 KB, 12 views)
Reply With Quote
  #2  
Old 09-19-2016, 07:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data not completely shifting in Excel 2016 Windows 7 64bit Data not completely shifting in Excel 2016 Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 09-19-2016, 07:33 AM
vmarshall vmarshall is offline Data not completely shifting in Excel 2016 Windows 10 Data not completely shifting in Excel 2016 Office 2016
Novice
Data not completely shifting in Excel 2016
 
Join Date: Sep 2016
Posts: 3
vmarshall is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 09-19-2016, 07:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data not completely shifting in Excel 2016 Windows 7 64bit Data not completely shifting in Excel 2016 Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 09-19-2016, 10:54 AM
vmarshall vmarshall is offline Data not completely shifting in Excel 2016 Windows 10 Data not completely shifting in Excel 2016 Office 2016
Novice
Data not completely shifting in Excel 2016
 
Join Date: Sep 2016
Posts: 3
vmarshall is on a distinguished road
Default

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!
Reply With Quote
Reply

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
Data not completely shifting in Excel 2016 Excel or Access Shifting data Aarotech Excel 1 01-27-2013 06:43 AM
Data not completely shifting in Excel 2016 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft