Line Spacing & hyperlink - ajit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. The content of cells in worksheet shows like a double line spaced
contents. When I try to make heights of that cell lower, the part of the
contents gets disappeared. Can I type the contents in a cell in single line
space, or double line space like in MS Word? How?

2. When I hyperlink a cell with a file in C:\My documents\Arrears.xls, and
click the cell, the error flashes "Can not open a specified file". But other
files in c:\My docuements can open by hyperlinking. What may be the problem
with that particular file Arrears.xls?
 
#1. You can make the rowheight larger, then use Format|Cells|Alignment tab and
make the Vertical alignment top, center, or bottom.

You could add some extra alt-enters to the beginning portion of the value and as
the last character.

#2. Maybe the file doesn't exist anymore--renamed/deleted? Or spelling/typo
error.
 
No, I have hyperlinked the cell by left clicking
->Hyperlink->select file by "file", so there is no
question of misspell or double quotes. With the
same procedure, other files in that directory,
open smoothly. Pl. guide.

David McRitchie said:
Part 2 looks like you may have spelling errors as well as not
enclosing a filename with spaces in double quotes.
=HYPERLINK("[c:\temp folder\xyz abc.xls]'Sheet One'!$C$5","Sheet One")

additional examples in
http://www.mvps.org/dmcritchie/excel/sheets.htm


Ajit Munj said:
1. The content of cells in worksheet shows like a double line spaced
contents. When I try to make heights of that cell lower, the part of the
contents gets disappeared. Can I type the contents in a cell in single line
space, or double line space like in MS Word? How?

2. When I hyperlink a cell with a file in C:\My documents\Arrears.xls, and
click the cell, the error flashes "Can not open a specified file". But other
files in c:\My docuements can open by hyperlinking. What may be the problem
with that particular file Arrears.xls?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Hyperlinks 2
Activating hyperlinks 3
Hyperlink in cell with line breaks 4
Insert a hyperlink as the text in the cell? 2
Carriage return 1
format to a specific number of spaces 2
How to read all lines from a text file into cells C10:Cxxx ? 1
line spacing in wrapped cell 3

Back
Top