Free Microsoft Excel 2013 Quick Reference

"Merge and center" grayed out in excel form

There are several functions that are disabled in the workbook form.
Hyperlink, create list and merge and center are grayed out and can not be
selected. If I open a new workbook this are available to use. The only
difference that I can see between each other is that one is "Shared".


Post your answer or comment

comments powered by Disqus
There are several functions that are disabled in the workbook form.
Hyperlink, create list and merge and center are grayed out and can not be
selected. If I open a new workbook this are available to use. The only
difference that I can see between each other is that one is "Shared".

I'm having trouble with several of my menu options being grayed out in Excel
2003. When I have a blank workbook option, several options are not available
to me: options, security, protection, macros, formula auditing, inserting
rows, columns, pictures, etc. However, if I sign into my husband's user
account, those options are all available to me. My profile is assigned as an
administrator, so I should have full accesss. The odd thing is that this is
only doing this in Excel and no other office programs.

My company gives us Excel docs with macros to report our financials. My main
frustration is that I don't have the option to change my security levels to
enable macros under my profile using Excel. I have the option to enable
macros under my husband's profile when I sign into his.

Any ideas?

I'm having trouble with several of my menu options being grayed out in Excel
2003. When I have a blank workbook option, several options are not available
to me: options, security, protection, macros, formula auditing, inserting
rows, columns, pictures, etc. However, if I sign into my husband's user
account, those options are all available to me. My profile is assigned as an
administrator, so I should have full accesss. The odd thing is that this is
only doing this in Excel and no other office programs.

My company gives us Excel docs with macros to report our financials. My main
frustration is that I don't have the option to change my security levels to
enable macros under my profile using Excel. I have the option to enable
macros under my husband's profile when I sign into his.

Any ideas?

I have copied several tables from Word 2003 into Excel 2003 and I am no
longer able to merge and center within the document. What disabled that
option and how do I re-enable it?

Thanks in advance,
Barb Reinhardt

Hi. I am running Office 2002, and the Options menu under Tools is
grayed out. I tried uninstalling and reinstalling Excel, but no
change. Nothing is set in protection, and the other programs in Office
are unaffected.
Any ideas?? Thanks!

Excel should let me use the merge and center button with unprotected cells
while other cells are maintained protected.

----------------
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...lic.excel.misc

Please send me the keyboard shortcut key for merge and center cell in excel
2003.

Hi,

This may not be the right place to post this but this is where I'll start.
Network administrator for a Windows 2003 domain w/ XP clients. One of my
users has an Excel spreadsheet w/ macros that is used for various
administrative tasks (non I.T.) The spreadsheet always pops the macro warning
dialog when it starts up and for some users it has become an "annoyance".

I tried to sign the macro w/ my domain CA-issued code signing cert but when
I did this, only I was able to click the box to "Always trust macros from
this publisher.." - the box was grayed out for everyone else (non-admins).

Obviously I'm missing or don't understand something - I do not have the
"Trusted Publisher lockdown" enabled in Group Policy and as this is the first
time we've played around with code-signing I don't believe that any
GP-initiated restrictions have been set in the past (I'm the only one working
on GP).

Anyone have any thoughts? Suggestions?

Thanks...

I have some spreadsheets that were created by someone else. The "Merge and Center" button stays inactive all of the time. No matter what I do, I cannot get it to go active with these particular spreadsheets. I need it too. It is Excel XP.

Hi!
I can choose some cells in a sheet to protect them and prevent any one to change.
it's supposed to change and edit in the other cells.
the problem which I face when I try to use "merge and center" or to insert picture or autoshapes ..etc. in unprotected cells!

Hi

The delete function to delete columns is grayed out on the menu. I cannot
delete columns. I did try and repair excel but it stll stays grayed out

Dears,

I upgraded my office from 2003 to 2007, now when i want to edit any of my macros (Macros -> View) all buttons excep run are grayed out! I checked in Microsoft office setup installed features, and VBA for office applications are installed...

any help

Hi,

I am working on a spread sheet and can't get some cells to merge. It worked a few lines up but no were else. This sheet is shared by others in the company. For what ever reason the merge and center button will not light up. I tryed the clicking enter but no go. Out of 83 lines maybe 1/3 have the merged cells, I even tryed coping and pasting with no success.

Thanks

I am developing a report, the current format like below, The number of rows and columns could be changed dynamically.

cc dd dd dd
aa zz zz zz
bb bb gg bb
cc dd dd dd
aa aa aa aa

Is there a way I can remove all consecutive duplicated records in each row by merging and centering the cells?

Thanks very much!

I have a worksheet where I have certain columns and rows locked and the rest
is available for user input. I used Tools/Protection/and have a check in
front of Select unlocked cells and Format cells. It is password protected.
This works great except it will not allow you to use the merge and center
function on the toolbar. You can copy the same text into each cell below,
but it is much easier to read when you merge and center all of the selected
cells. Any idea why merge and center is not available when format cells is
checked?
Any/all help appreciated!!

Hello All,
I am having issues inserting columns in vba when some of the cells are merged and centered. the datecolumns number is the difference between days in the previous billing cycle and days in the new cycle.

Here is the rough code I am starting with (it continues for more DateColumns but this gives you the just of it):
    DateColumns = currentdays - Prevdays
    If DateColumns = 1 Then
        Columns("R:R").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    End If
    If DateColumns = 2 Then
        Columns("R:S").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    End If
    If DateColumns = 3 Then
        Columns("R:T").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    End If
    If DateColumns = 4 Then
        Columns("R:U").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    End If
    If DateColumns = -1 Then
        Columns("R:R").Delete Shift:=xlToLeft
    End If
    If DateColumns = -2 Then
        Columns("R:S").Delete Shift:=xlToLeft
    End If
    If DateColumns = -3 Then
        Columns("R:T").Delete Shift:=xlToLeft
    End If
    If DateColumns = -4 Then
        Columns("R:U").Delete Shift:=xlToLeft
    End If
when a column contains merged and centered data, the code has issues correctly identifying which columns it selects to insert or delete. Any suggestions would be greatly appreciated.

Thanks in advance

Why is the merge cells function grayed out in a shared workbook? Anyone got a
fix?

Is it possible to have a formula that will sum a pair of cells in column A, then merge cells and center the total in column B?

Is there any keyboard shortcut for "merge and center" ?

I looked up for it in many references, but couldn't find anything. please help

Hello

When making a spreadsheet shared the merge and center function in the
toolbar disables. Can anyone help to make it remain enabled all time?

Regards
Gina

I have this code:
Sub x()

Dim rCopy As Range, rng As Range

Set rCopy = Sheets("version").Range("A3")
With Sheets("final")
    For Each rng In .Range("H2", .Range("H" & Rows.Count).End(xlUp))
        Set rCopy = rCopy.Offset(, 3)
        rCopy.Value = rng.Value
    Next rng
End With

End Sub
I need to modify the code so the macro will also " merge and center" the cell with text and the next cell from row 3.
Please open the attached file.

Hello everyone,
does anybody know how to save a value as a Default of a text box in Excel form? So when you open the Excel form next time, it will remember the last entered value.
I use Show and Hide methods for Excel forms.
I did not find any Open method with Design mode to save the last entered value as a Defaullt.
Thank you.
surotkin

How to use the "Find and Replace" dialog box in Excel

Hi folks,

I am new here. I am not great in excel vba and need some help in a macro. I am trying to design a macro which will have the user to select a MS Access database file and the macro will execute a particular query in it and give the output in excel. I tried recording the macro and changing the file path wherever applicable but it doesn't work.

I get the error in .ListObject.DisplayName = "Table_Query_from_MS_Access_Database"
.Refresh BackgroundQuery:=False

Require your help. Below is the recorded code.

	VB:
	
 Macro6() 
     '
     ' Macro6 Macro
     '
     '
    With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _ 
        "ODBC;DSN=MS Access Database;DBQ=C:Documents and Settingssivaram.aashishDesktopProduction.mdb;DefaultDir=C:Documents
and Setting" _ 
        ), Array( _ 
        "ssivaram.aashishDesktop;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" _ 
        )), Destination:=Range("$A$1")).QueryTable 
        .CommandText = Array( _ 
        "SELECT `Copy Of Query1`.Month, `Copy Of Query1`.Specialist, `Copy Of Query1`.Category, `Copy Of Query1`.`SumOfCY
SAS`, `Copy Of Query1`.`SumOfCY GM$`, `Copy Of Query1`.`SumOfPY SAS`, `Copy Of Query1`." _ 
        , _ 
        "`SumOfPY GM$`" & Chr(13) & "" & Chr(10) & "FROM `C:Documents and Settingssivaram.aashishDesktopProduction.mdb`.`Copy
Of Query1` `Copy Of Query1`" & Chr(13) & "" & Chr(10) & "WHERE (`Copy Of Query1`.Month='September')" _ 
) 
        .RowNumbers = False 
        .FillAdjacentFormulas = False 
        .PreserveFormatting = True 
        .RefreshOnFileOpen = False 
        .BackgroundQuery = True 
        .RefreshStyle = xlInsertDeleteCells 
        .SavePassword = False 
        .SaveData = True 
        .AdjustColumnWidth = True 
        .RefreshPeriod = 0 
        .PreserveColumnInfo = True 
        .ListObject.DisplayName = "Table_Query_from_MS_Access_Database" 
        .Refresh BackgroundQuery:=False 
    End With 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines



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