Adding lines to a sheet (Excel ver. xp)

Topic

New Reply

Please help me learn how to add lines to a excel page as I have additional info to add to 6 different pages and I do not want the info added from one sheet to cause the ending column numbers of that sheet to spill over to the next sheet Thank you, John

Reply | Quote

Replies

I do not understand. Could you please be a little more specific on what you have and what you need?

Steve

Reply | Quote

I do not understand. Could you please be a little more specific on what you have and what you need?

Steve

Reply | Quote

It is almost impossible to answer this questions without seeing the workbook. What do you mean by “cause the ending column numbers of that sheet to spill over to the next sheet?” Do you mean when the worksheet is printed?

If your worksheet currently has data that fills a page from left to right, there are many things that you may need to do to add more data and not bump columns to the next page. You might be able to reduce the page margins. You might be able to just make some columns narrower. You might have to reduce the font size in some columns and then make those columns narrower.

There are many things that might do what you need, but I can’t guess which one or ones might be appropriate without seeing the workbook.

Your question is also not clear if you are adding rows or columns.

Reply | Quote

To clarify everone’s question. I have stock numbers and locations going vertically down the worksheet, then to the right of these there is the same format with different stock numbers and locations in column C an Ds, etc. when the page is filled up, it goes to the next page and starts again the same formant. The problem I have is that we now need to add new stock numbers to add to the listing which must be inserted into the columns. This will cause some of the existing info at the end of the page to spill over to the next page which is not desireable because we will have to redo everything from the beginning all over again….John

Reply | Quote

John,
You mention “pages”, and the information “spilling over to the next page”. Do you have a spreadsheet that you print out and the columns now do not fit on the page?

Assuming you have an issue with printing a report out, have you checked View > Page Break Preview to see where the new page breaks are? Then you can either adjust the page breaks by sliding them up or down, or adjust your data so it fits the way you would like.

Errol

Reply | Quote

John,
You mention “pages”, and the information “spilling over to the next page”. Do you have a spreadsheet that you print out and the columns now do not fit on the page?

Assuming you have an issue with printing a report out, have you checked View > Page Break Preview to see where the new page breaks are? Then you can either adjust the page breaks by sliding them up or down, or adjust your data so it fits the way you would like.

Errol

Reply | Quote

I am still not sure of what you have and more importantly what you want.

If you have a list of numbers in multiple columns and you want to insert a new number within a column and shift all the values 1 cell, there is not a direct way to do this in excel. There are various ways to set this up and use formulas or a macro to create the “output” (which would be separate from the list itself).

An alternative to do this more directly is to create the list in WORD. Word allows you to create a list and have it be spread over multiple columns, so you could add to the list anywhere and the list would move all the items after the insertion. Excel does not work this way.

Steve

Reply | Quote

I am still not sure of what you have and more importantly what you want.

If you have a list of numbers in multiple columns and you want to insert a new number within a column and shift all the values 1 cell, there is not a direct way to do this in excel. There are various ways to set this up and use formulas or a macro to create the “output” (which would be separate from the list itself).

An alternative to do this more directly is to create the list in WORD. Word allows you to create a list and have it be spread over multiple columns, so you could add to the list anywhere and the list would move all the items after the insertion. Excel does not work this way.

Steve

Reply | Quote

In terms of Excel, what is a “page”? Excel does not have pages. It has continuous spreadsheets, and workbooks that contain one or more worksheets. Are you talking about the sheets of paper that you get when you print a spreadsheet? The amount of data that is displayed on the screen at one time? Can you upload a workbook with dummy data that shows what you are asking?

Reply | Quote

In response to everyone who is trying to give me assistance when I refer to a page it is a page that is printed on the printer. There are 6 pages that are printed from this spreadsheet that I am trying to get assistance on. I want to keep all the information on the spread sheet that previously printed out on the printed page before I add the additonal SKU’S on the same printed page after I add all the different new SKU’S. Therefore I need more rows available for each Page that ends up being printed on the printer so that what is at the bottom of the orginal page does not appear appear at the top of the next page that is printed out with the other printed pages information…thanks, John

Reply | Quote

There are a number of things that you might be able to do.

1- On the File menu select Page Setup. Then click on the Margins tab. Reduce the top and/or bottom margins to allow more room on the page. This may cause problems if you have Headers or Footers defined on the Header/Footer tab.

2- Select all of the rows and then change the font size to a smaller size. After doing this, select Row from the Format menu and then click on Autofit.

3- Reduce the height of any blank rows.

4- Select Page Setup from the File menu. Click on the Page tab. In the Scaling section, click on the Fit to radio button, and then put a 6 in the pages high. This may not work depending on what was done to cause the current page breaks.

Again, this is almost impossible to advise you on without seeing the workbook. If you could upload a workbook with dummy data in it you will probably get the resolved very quickly.

Reply | Quote

There are a number of things that you might be able to do.

1- On the File menu select Page Setup. Then click on the Margins tab. Reduce the top and/or bottom margins to allow more room on the page. This may cause problems if you have Headers or Footers defined on the Header/Footer tab.

2- Select all of the rows and then change the font size to a smaller size. After doing this, select Row from the Format menu and then click on Autofit.

3- Reduce the height of any blank rows.

4- Select Page Setup from the File menu. Click on the Page tab. In the Scaling section, click on the Fit to radio button, and then put a 6 in the pages high. This may not work depending on what was done to cause the current page breaks.

Again, this is almost impossible to advise you on without seeing the workbook. If you could upload a workbook with dummy data in it you will probably get the resolved very quickly.

Reply | Quote

John,
In adjusting the pages in the Page Break Preview mode, you can see the page breaks as blue horizontal and vertical lines. If the lines are dashed, they are “soft” breaks. As soon as you drag one to a new location (say, up three rows), the line becomes solid and then becomes a “hard” page break. Should you need to add rows in a given page, there might come a point where the number of lines between hard breaks is really too much for one page, and a new soft break will appear. Adjust accordingly.

Errol

Reply | Quote

THANKS TO ALL FOR THE ADDITIONAL INFORMATION…I WILL CERTAINLY GIVE THEM A GO. JOHN

Reply | Quote

THANKS TO ALL FOR THE ADDITIONAL INFORMATION…I WILL CERTAINLY GIVE THEM A GO. JOHN

Reply | Quote

John,
In adjusting the pages in the Page Break Preview mode, you can see the page breaks as blue horizontal and vertical lines. If the lines are dashed, they are “soft” breaks. As soon as you drag one to a new location (say, up three rows), the line becomes solid and then becomes a “hard” page break. Should you need to add rows in a given page, there might come a point where the number of lines between hard breaks is really too much for one page, and a new soft break will appear. Adjust accordingly.

Errol

Reply | Quote

In response to everyone who is trying to give me assistance when I refer to a page it is a page that is printed on the printer. There are 6 pages that are printed from this spreadsheet that I am trying to get assistance on. I want to keep all the information on the spread sheet that previously printed out on the printed page before I add the additonal SKU’S on the same printed page after I add all the different new SKU’S. Therefore I need more rows available for each Page that ends up being printed on the printer so that what is at the bottom of the orginal page does not appear appear at the top of the next page that is printed out with the other printed pages information…thanks, John

Reply | Quote

In terms of Excel, what is a “page”? Excel does not have pages. It has continuous spreadsheets, and workbooks that contain one or more worksheets. Are you talking about the sheets of paper that you get when you print a spreadsheet? The amount of data that is displayed on the screen at one time? Can you upload a workbook with dummy data that shows what you are asking?

Reply | Quote

To clarify everone’s question. I have stock numbers and locations going vertically down the worksheet, then to the right of these there is the same format with different stock numbers and locations in column C an Ds, etc. when the page is filled up, it goes to the next page and starts again the same formant. The problem I have is that we now need to add new stock numbers to add to the listing which must be inserted into the columns. This will cause some of the existing info at the end of the page to spill over to the next page which is not desireable because we will have to redo everything from the beginning all over again….John

Reply | Quote