How do you make lines appear on an excel sheet?

Show or hide drawing gridlines Drawing gridlines appear only in Print Layout view.

• On the View tab, in the Show/Hide group, select the Gridlines check box. " alt="Word Ribbon Image">
  

Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

>this may help you
http://office.microsoft.com/en-us/excel/HP052001271033.aspx

Depending on what version of Excel you are using try the following:
The lines are called gridlines

1. Click the worksheet.
   
   
2. On the File menu, click Page Setup, and then click the Sheet tab.
   
   
3. Select the Gridlines check box.

Note Large worksheets print faster if you do not select the Gridlines check box.

Please rate this solution...Thanks

Print or convert it to pdf then you may copy/paste from the pdf to a new unprotected sheet.

Doesnt work for formula.

Speed up Excel 2007 startup The Problem If Excel isn't running already, double-clicking a file will start Excel itself almost immediately, but the clicked file will be loaded only after about one minute.
The Solution At least on Windows XP the problem can be solved as described below.

1. Application Explorer
2. Menu Tools
3. Menu item Folder Options
4. Tab File Types
5. List item XLS
6. Button Advanced
7. List item Open
8. Button Edit...

In the dialog box that appears you need to make two adjustments:
Application to perform action:At the end of the line after /e append a space character followed by "%1" (including the quotes)DDE Application Not Running:Insert new text: [rem see command line] (including the brackets) Details We experienced the problem after updating to MS Office 2007. My father noticed that an Excel sheet gets loaded immediately if you include the path of EXCEL.EXE in the command line. Loading documents via DDE, as Explorer does it, seems to take much more time, at least if the application is not already running. The modifications described above will pass the file path immediately when the application is started, the DDE command that gets executed later on is only a remark, as an empty field would result in passing the default action from two lines above that field. The /e seems to ensure that Excel will not open an empty sheet, so I originally dropped that because usually no empty sheet is opened when a file is specified. However I got a report from someone using /e, and as it didn't cause any harm for me either, I now suggest to leave it in place. If Excel is running already, additional documents will be opened via DDE as before, resulting in only one Excel process running.
Word Time and again I've been asked whether I knew a similar trick for Word. Even without any tricks Word starts fairly fast, but even there adding "%1" gave me a slight increase in startup speed. I don't exactly know what this [REM _DDE_Direct] is. It looks like some kind of "special comment", that could have some effect despite being a comment. I decided to copy that comment to the DDE Application Not Running box, and could not detect any ill effects. I also kept the /n and the /dde on the command line, simply because I could find no harm in it.
Uninstall If you try out these suggestions, but they don't work out for you, reverting to the way it was before might prove more difficult than you would expect. It seems the dialog where you make your changes will always append a %1 to the command line when you press OK and it isn't present already. The only solution I could find was using regedit to remove the %1 without using the dialog. The command is stored under the default key at HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command. If you choose to revert the DDE settins using regedit as well, you can simply remove the whole ddeexec\IfExec subtree.

how i connect one excel sheet to another excel

Hi,

I am assuming that the reason you are using Excel is because of the gridlines. An "engineering drawing" done in Excel would break when rotated especially the angular lines. The reason is Excel does not have the necessary engine to display (render) such drawings. By Excel alone, there is no way out of this problem.

However, there is a workaround. After making the drawing, before rotating it, do a Print Preview. Open an image manipulation program, even a simple one such as PaintShop Pro. Capture the image on the Print Preview. Open another Excel sheet, copy and paste the image from the image manipulation program to the Excel sheet.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information. Good luck and kind regards. Thank you for using FixYa.

on sheet2!a1 type =sheet1!a1 - anything you type on sheet1!a1 will appear on sheet2!a1

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.