Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Turn off the cell autosize

I have large sentences placed in various cells in a large table.

When i first put the text in, it shows the whole sentence spilling out of the cell.

If i then 'wrap text', the row height automatically increases to fit the whole sentence in.

I then manually adjust the row height back to what it was, and you can then only see the very beginning of the sentence. This is what i want it to look like.

The problem is if i then ever sort the cells so the sentence ends up somewhere else, which i often do, it auto resizes again.

So, how do I turn this auto resize thing off? I have looked everywhere i can think of.
(using excel 2004 for mac, which is very similar to 2003 for pc)

Thanks


Post your answer or comment

comments powered by Disqus
I would like to be able to turn off the cell pointer while my macro runs, so that the user can not see what the active cell is, and then turn it on again at the completion. Any clues?

Thanks for your help,

Rick.

I don't think you can turn off the automatic GetPivotData entry, but you can
try this:

Instead of selecting the pivot table cell to be used in your formula, type
in the cell address.

For example, if you try to use the pivot table value at cell B10 by
selecting it, Excel will build something like this:
=GETPIVOTDATA("Amount",$A$1,"Name","Part 1")
But, if you just type =B10...you'll still get the value in that cell.

Does that help?

Regards,
Ron

"Scott" wrote:

> The new version of Excel automatically prefills the formula with the
> GetPivotData function when I try to use Pivot Table data. I don't want to
> have this prefilled. How do I disable this.

Using Word and Excel 2003 on Windows.

In both Excel and Word recent versions have these little Paste Option square
graphics that appear when you paste text. When you click on the little
square, it pops up a menu of choices with radio buttons, about how you want
to handle formatting between source and target.

I hate them. On many levels. The concept of helping with moving formatting
from source to target is interesting, but I think that in Microsoft's zeal to
add features, they have sacrificed the basic use of the program in order to
serve a fairly sophisticated goal, and one that I believe doesn't serve all
of their users.

What's wrong with them? !) THEY BLOCK MY VIEW OF MY TEXT and 2) IT'S NOT
OBVIOUS HOW TO GET RID OF THEM. I have repeatedly been in a situation where I
am trying to do a series of cut and pastes, and literally have been unable to
read what I pasted in because of the icons that pop up. I find myself leaning
to the left or the right in a failed attempt to see behind them (I'm serious,
it's that bad sometimes).

When I try choosing all the radio button choices, none of them seem to
dismiss the graphic, at least in Word. In Excel I have come up with a
workaround that is to select some other text, in another cell, and sometimes
it seems that the little box disappears.

I move from computer to computer quite a bit, and so every time I use a new
one I come up against this. I think I've figured out how to turn them off on
my primary computer, but a little scouting here at a client has been
unsuccessful and so I'm frustrated.

Alternate implementations:

1. Just don't do it. Get rid of them. Bad UI, bad implementation to block my
view of my data. Ever. Stop the madness.
2. Make sure there is _always_ a "Turn this feature off" choice on the
dropdown. ALWAYS ALWAYS ALWAYS. If there is a way to turn it off somewhere
else, I have sure been unsuccessful finding it - I can't even figure out what
the name of the offending little formatting boxes are to look them up in the
Help, let alone find where you turn them off.

In the end, this seems like a feature that is aimed at non-power users. I am
quite comfortable reformatting my text manually - it is possible Microsoft
has data from some of their less experienced users that they can't, and need
something like this. Even if I liked the feature, after I choose one of the
alternatives, the little boxes stay displayed, what's up with that??? Please
please please don't punish power users by making it hard to turn off the
training wheels! Especially when they interfere with the basic purpose of the
software, which is to enter text/numbers and then edit it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Using Word and Excel 2003 on Windows.

In both Excel and Word recent versions have these little Paste Option square
graphics that appear when you paste text. When you click on the little
square, it pops up a menu of choices with radio buttons, about how you want
to handle formatting between source and target.

I hate them. On many levels. The concept of helping with moving formatting
from source to target is interesting, but I think that in Microsoft's zeal to
add features, they have sacrificed the basic use of the program in order to
serve a fairly sophisticated goal, and one that I believe doesn't serve all
of their users.

What's wrong with them? !) THEY BLOCK MY VIEW OF MY TEXT and 2) IT'S NOT
OBVIOUS HOW TO GET RID OF THEM. I have repeatedly been in a situation where I
am trying to do a series of cut and pastes, and literally have been unable to
read what I pasted in because of the icons that pop up. I find myself leaning
to the left or the right in a failed attempt to see behind them (I'm serious,
it's that bad sometimes).

When I try choosing all the radio button choices, none of them seem to
dismiss the graphic, at least in Word. In Excel I have come up with a
workaround that is to select some other text, in another cell, and sometimes
it seems that the little box disappears.

I move from computer to computer quite a bit, and so every time I use a new
one I come up against this. I think I've figured out how to turn them off on
my primary computer, but a little scouting here at a client has been
unsuccessful and so I'm frustrated.

Alternate implementations:

1. Just don't do it. Get rid of them. Bad UI, bad implementation to block my
view of my data. Ever. Stop the madness.
2. Make sure there is _always_ a "Turn this feature off" choice on the
dropdown. ALWAYS ALWAYS ALWAYS. If there is a way to turn it off somewhere
else, I have sure been unsuccessful finding it - I can't even figure out what
the name of the offending little formatting boxes are to look them up in the
Help, let alone find where you turn them off.

In the end, this seems like a feature that is aimed at non-power users. I am
quite comfortable reformatting my text manually - it is possible Microsoft
has data from some of their less experienced users that they can't, and need
something like this. Even if I liked the feature, after I choose one of the
alternatives, the little boxes stay displayed, what's up with that??? Please
please please don't punish power users by making it hard to turn off the
training wheels! Especially when they interfere with the basic purpose of the
software, which is to enter text/numbers and then edit it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

Hello

Does anyone know how can I turn off the message
"Do you want to replace contents of the destination cells"?

I always do want to replace them...

turn off a cell's right click

for "validation" reason's, i would like to turn off/disable a cell's right click options...

???

thank you.

I have a macro that does many functions, among them is deleting a worksheet. If the user has the Office Assistant feature ( the silly paper clip thing) on, the macro stops for the Office Assistant messages. Is there a way through VBA to turn off the Office Assistant if it is activated.

Thanks

Is there such a thing as:
-Additional code-
With Dest.Sheets(1).Options
.DisplayGridlines = False

It does'nt work can anyone suggest anyway to turn off the DisplayGridlines on an email attachment so that when the attachment is open on the data is viewable not the gridlines - This ones really driving me nuts!!

Many thanks for your help

I want to turn off the compatibility mode because Excel 2007 becames really slow when opening and working with older files.

Is it possible? In the previous Excel version that didn't happen!

Thanks in advance

JC

How do I turn off the display of a specific worksheet, ( e.g. the A B C D E.... row header, and the 1 2 3 4.... column header ) I know that the command :-

ActiveWindow.DisplayHeadings = False

turns off the header display of the active window, but I want to turn off the header display of the current worksheet.
How do I do it ?

How do you turn off the date that automatically appears at the bottom of a
page when printing an email or HTML?

I am running a series of optimisations using the SolverSolve function in VB.
Every time the solver works it wants me to click ok in the results dialog
box. This slows things down somewhat. Is it possible to turn off the results
box or is there some VB code that gets me past this issue.

Is it possible to temporarily turn off the keyboard, i.e. similar to how you
can do with screen updating:

Application.ScreenUpdating = False
Application.ScreenUpdating = True

Thanks in advance

WHEN USING EXCEL IN THE PAGE BREAK PREVIEW VIEW, IS THERE A WAY TO TURN OFF
THE BIG GRAY PAGE NUMBERS THAT APPEAR IN THE MIDDLE OF THE PAGES ON SCREEN?

I have a report that exports data to a .csv format, which is opened using excel. For some of the values led by a hyphen, the error #NAME? populates. For others, the value led by a hyphen sticks, with no error. I need to turn off the trigger globally, so that my values led by a hyphen do not present the #NAME? error. I have tried changing to text format, I know that enclosing in " " or adding a space before the value allows it to stick - but I need a faster glocal change since there are many affected rows on this report.

Any guidance would be much appreciated!!

Thank you,

Heather

I am sure someone, somewhere can use the function, I absolutely hate it.

Can anyone assist me in turning off the hyperlink style format that appears
when an @sum formula is added to a spreadsheet in excel???

I am trying to turn off the text to speech facility in Excel. Please help.

After I do a 'drag to copy' the Autofill Options box appears and is always in
the way for my next 'drag to copy'. I have to click a blank cell off to the
side and hit the space bar to get it to turn off (temporarily).

Hi,

I type text like 2-1 into my cell and it turns it into Feb-2.
Is the a way to turn this off without using the ' in from of the text.

Also way to do this without formatting the cell as text since I need to save in
.dbf format which doesn't support this option.

Thanks,

Dino

When I open a spread sheet and left click my mouse in a cell, I can't enter
any data. If I move the mouse, it highlights the cells the cursor touches
and I can't turn that off. Hitting the Esc key does nothing. I'm locked out
of all the toolbar functions. The only way I can terminated the program is
by going to task manager and 'end task'. The EXT indicator isn't on, but
even if it was, I should be able to get out of it by hitting F8. If I try to
X out of Excel by going off the page and selecting anything, the cells just
keep getting highlighted. Yes, I've reinstalled the program. I'm using
Windows XP Pro with Office 2003

Hi,

I recently installed Office 2002 onto a new computer and found that whenever I drag-and-drop any amount of data from one cell to another, a loud obnoxious noise plays when I release the drag-and-drop data.

I was using the same version of Office on my old computer and did not have this problem.

I'm guessing it's a clipboard issue, since when I open the Excel clipboard (where I currently have all options as unchecked) and copy something so it is captured there, the same noise plays.

I already have turned off Windows sounds via the Control Panel and have no clue how to turn off this sound. Any advice is appreciated. Thanks.

I am working with a friend who turned off the" I don't know the name of it" so I will try to explain.

In the past I was able to enter the number 1 in a cell and then drag that cell down the colum. The number would increase by one. it would enter 123... and i went down the coloum. This was good for finding how many rows I have.

He has turned off something now when I drag the cell down it copies what was in the cell above eg : I enter the number 1 in a cell and drag it down I get all 111111 all the way down.

So how to I turn this function on?

Is it possible to turn off or hide the top of the excel page, ie the :
excel symbol and name and the row beneath it - file, edit, view etc?

i am adding an exit command button to save all the information and exit and i need the users to only use this to exit.

regards

Bob

Hi All,

The following is the code I use to run a macro to automatically send a email from excel. Can anyone please help me with turning off the ScreenUpdating while macro runs? And also help me with trimming the code to perfection if possible. Please understand am very new to VBA and the below mentioned code is very important for me:

Thank you all in advance.

Sub Mail_Selection_Range_Outlook_Body()
' Don't forget to copy the function RangetoHTML in the module.
' Working in Office 2000-2007
Dim rng As Range
'Dim OutApp As Object
'Dim OutMail As Object
Dim objol As New Outlook.Application
Dim objmail As MailItem
Dim Pathname
'Add this Dim line
Dim StrBody As String

'Build the string you want to add
' StrBody = "Hi All," & "
" & _
" " & "
" & _
"Please find below the Interval Tracker:-" & "
"

'Or use this for cell values
'StrBody = Sheets("Sheet2").Range("A1").Value & "
" & _
Sheets("Sheet2").Range("A2").Value & "
" & _
Sheets("Sheet2").Range("A3").Value & "
"

'And change the HTMLBody line to this
' .HTMLBody = StrBody & RangetoHTML(rng)
Set rng = Sheets("SnapShot").Range("A1:H21").SpecialCells(xlCellTypeVisible)
'Set rng = Nothing
On Error Resume Next
'Only the visible cells in the selection
Set rng = Sheets("SnapShot").Range("A1:H21").Selection.SpecialCells(xlCellTypeVisible)
'You can also use a range if you want
'Set rng = Sheets("SnapShot").Range("B3:H20").SpecialCells(xlCellTypeVisible)
On Error GoTo 0
If rng Is Nothing Then
MsgBox " Team the selection is not a range or the sheet is protected" & _
vbNewLine & "please correct and try again. - Sandan", vbOKOnly
Exit Sub
End If
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = "someone.com"
.CC = "someone.com"
.BCC = "someone.com"
.Subject = "Interval Performance Tracker"
.HTMLBody = StrBody & RangetoHTML(rng)
'.HTMLBody = RangetoHTML(rng)
'.Send 'or use .Display
.Display

End With
Set objmail = Nothing
Set objol = Nothing

'Wait for System to catch up and send
Application.Wait (Now + TimeValue("0:00:04"))
Application.SendKeys "%s"
'Application.Wait (Now + TimeValue("0:00:04"))

End Sub
'Application.Wait (Now + TimeValue("0:00:15"))
'Application.SendKeys "%S"
' .Send
' End With
' On Error GoTo 0
' With Application
' .EnableEvents = True
' .ScreenUpdating = True
' End With
'Set OutMail = Nothing
' Set OutApp = Nothing
'End Sub

Function RangetoHTML(rng As Range)
' Changed by Srinivas Sandan 28-Mar-2007
' Working in Office 2000-2007
Dim fso As Object
Dim ts As Object
Dim TempFile As String
Dim TempWB As Workbook

TempFile = Environ$("temp") & "/" & Format(Now, "dd-mm-yy h-mm-ss") & ".htm"

'Copy the range and create a new workbook to past the data in
rng.Copy
Set TempWB = Workbooks.Add(1)
With TempWB.Sheets(1)
.Cells(1).PasteSpecial Paste:=8
.Cells(1).PasteSpecial xlPasteValues, , False, False
.Cells(1).PasteSpecial xlPasteFormats, , False, False
.Cells(1).Select
Application.CutCopyMode = False
On Error Resume Next
.DrawingObjects.Visible = True
.DrawingObjects.Delete
On Error GoTo 0
End With

'Publish the sheet to a htm file
With TempWB.PublishObjects.Add( _
SourceType:=xlSourceRange, _
Filename:=TempFile, _
Sheet:=TempWB.Sheets(1).Name, _
source:=TempWB.Sheets(1).UsedRange.Address, _
HtmlType:=xlHtmlStatic)
.Publish (True)
End With

'Read all data from the htm file into RangetoHTML
Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.GetFile(TempFile).OpenAsTextStream(1, -2)
RangetoHTML = ts.ReadAll
ts.Close
RangetoHTML = Replace(RangetoHTML, "align=center x:publishsource=", _
"align=left x:publishsource=")

'Close TempWB
TempWB.Close savechanges:=False

'Delete the htm file we used in this function
Kill TempFile

Set ts = Nothing
Set fso = Nothing
Set TempWB = Nothing
End Function


No luck finding an answer? You could always try Google.