Tag Info

Hot answers tagged

3

Maybe what you want to do is simply data filtering. This functionality is available in main spreadsheet programs and I will explain how to use it on an example. Plants are listed in a table: For each plant, it is written its type (fruit, vegetable...) in column "type" and its color in column "color". Select the header items and apply "auto-filter" on ...


2

You will need to add them to the .acl file as explained in this KB. To use your AutoCorrect entries on another computer (or to share them with another user profile on your computer), locate the .acl files in the %AppData%\Microsoft\Office folder. (You can type the path in Windows Explorer exactly as shown here and the %AppData% environment ...


2

If you're open to VBA, there's the Application.AutoCorrect object that has .AddReplacement method KB. You could do something like this - Sub test() Dim rng As Range Set rng = Range("A1:A100") With Application.AutoCorrect For Each c In rng .AddReplacement c, c.Offset(, 1) Next End With End Sub That's assuming you list is in A1:B100 where ...


2

I should uncheck the "formula" box in Tools > Options > View but there is no "Tools" menu In Excel 2010 you can press ctrl+` (grave accent) to toggle the display of formulas. Display or hide formulas You can control the display of formulas in the following ways: Switch between displaying formulas and formula results on a worksheet ...


1

Click the Developer ribbon > Document Panel and untick "Always show Document Information panel on document open and initial save". (If you don't see the Developer ribbon, you need to enable it first via Right-Click on any ribbon > Customize the Ribbon > tick "Developer" in the list of ribbons on the right.)


1

This is an interesting question, and I can see your question is actually 2 parts. Why does the macro choose Split instead of Pane and How to work around it. I don't know the answer to 1, so I'll focus on 2 only. Since you want to unfreeze you need to use freeze! Sub DoThis() Columns("E:E").Select ActiveWindow.FreezePanes = True End Sub


1

If you can't set a min/max then my suggestion would be to use a dummy series. The points could be set using ceiling/floor functions on your data set for the second one you would have a dummy series something like x y 201 491 204 492 Give the series the name "", and format the dummy series so there are no points and no lines. No one will see the ...



Only top voted, non community-wiki answers of a minimum length are eligible