Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-01-2015, 07:56 AM
jgrubby jgrubby is offline I want to continue a spreadsheet I did not create Windows 7 32bit I want to continue a spreadsheet I did not create Office 2010 32bit
Novice
I want to continue a spreadsheet I did not create
 
Join Date: Oct 2015
Posts: 1
jgrubby is on a distinguished road
Default I want to continue a spreadsheet I did not create


I have a spreadsheet that stops at line 24 and continues across to M. It will always stop at M but I want to continue it from 24 down to line 70. I've tried to use "fill" and "down" but it just messes up and ends with a bunch of hashtags. What am I doing wrong? Do I have to enter the formula in each individual cell? Is there no easy way of doing this? I attached the spreadsheet, and the blank cells are just words. Any help would be wonderful. Thanks.
Attached Files
File Type: xls Sample.xls (28.5 KB, 10 views)
Reply With Quote
  #2  
Old 10-01-2015, 03:45 PM
macropod's Avatar
macropod macropod is offline I want to continue a spreadsheet I did not create Windows 7 64bit I want to continue a spreadsheet I did not create Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Selecting the last row, then extending the selection downwards, followed by Ctrl-D allows you to continue to data etc. down as far as you want. The ### output simply tells you the cells aren't wide enough to display their contents. You can widen the columns and/or make the font smaller to overcome that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-01-2015, 04:15 PM
NoSparks NoSparks is offline I want to continue a spreadsheet I did not create Windows 7 64bit I want to continue a spreadsheet I did not create Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Go to the Formulas ribbon, in Formula Auditing section select Show Formulas so you can see the progression of all the formulas.

In column B all those D3 should be $D$3 and in column K the K3 should be $K$3 for the formulas to maintain the addition of the constant when being dragged.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to continue a spreadsheet I did not create Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes esherwood Mail Merge 1 07-21-2014 09:55 PM
I want to continue a spreadsheet I did not create Page numbers will not continue throughout document winningson Word 2 01-27-2013 06:34 AM
Continue SEQ field numbering across documents gmaxey Word 0 12-30-2012 09:16 AM
Create template that auto-fills from excel spreadsheet m.buskirk5 Publisher 0 07-02-2012 03:09 PM
I want to continue a spreadsheet I did not create Bullets & Numbering - How to continue numbers in second slide? Learner7 PowerPoint 2 05-17-2010 05:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 PM.


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