Linked Questions
102 questions linked to/from How do I add VBA in MS Office?
5
votes
2
answers
37k
views
How do you open the VBA editor in MS Word 2013? [duplicate]
How do I get to the VBA editor in MS Word 2013? All my searches return information on Excel.
-2
votes
1
answer
967
views
How do I run a VBA function in Excel? [duplicate]
I want to run this function
I opened the developer tab in excel, no clue what to do now. I tried creating a "macro button", and then paste the function code in the macro script, but if I press play I ...
0
votes
0
answers
31
views
How do I create a macro in Excel for Mac? [duplicate]
I have found this thread on this topic
How to get the list of sheet names of ms-excel?
But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to ...
65
votes
22
answers
808k
views
Unable to get Excel to recognise date in column
I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...
63
votes
5
answers
378k
views
How to split a string based on ":" in MS-Excel?
My excel column is filled with words like this:
1.) ABC:DCF
2.) DCF:FED
I want to split each word based on " : " and put the result in adjacent columns such that "ABC:DCF" in cell "A:1" becomes "ABC"...
57
votes
11
answers
46k
views
How to keep selected text highlighted when focus changes in Microsoft Word/Excel
Related to this question: Show cell selection in Excel when not in focus except that my case concerns Microsoft Word.
When I select text or a column/row in Microsoft Word or Excel (2003, 2007, 2010 ...
20
votes
12
answers
167k
views
How to prevent cells from printing in Excel
How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do ...
18
votes
9
answers
74k
views
Excel function determine if a cell is visible
In conditional formatting I want to detect if the row above the current cell is hidden or visible. How can I detect if a cell is visible or not?
The only hack I can think of is:
Create a column with ...
18
votes
3
answers
147k
views
How can one "split" an Excel (.xlsx) file that contains multiple sheets into separate sheet[n].xlsx?
I think the title says it all for this question but to elaborate a bit further:
I have a .xlsx file which contains a few dozen sheets. I want to output all of those sheets as separate .xlsx files. ...
22
votes
4
answers
296k
views
Excel - How to vlookup to return multiple values?
I'm looking to use Excel to look up and return multiple reference values for a given key. VLookup does something very similar to what I need - but only returns a single match.
I assume it'll involve ...
10
votes
9
answers
40k
views
Can Excel show a formula and its result simultaneously?
I know that it's possible in Excel to toggle between displaying values and displaying formulas. I'm required to turn in assignments for a statistics class as a printed Excel sheet showing both the ...
21
votes
1
answer
93k
views
In Excel 2013, where are Visual Basic (VBA), Macros and AddIn tools?
In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?
11
votes
6
answers
52k
views
Saving Excel sheet as JSON file
Is there a simple way to convert a simple excel sheet to a JSON file?
For example the source sheet could look like:
A B
1 firstName age
2 Alice 22
3 Bob 33
and the ...
8
votes
4
answers
131k
views
Switch to first/last worksheet directly with keyboard
Is there a keyboard shortcut to directly go to first/last worksheet in Microsoft Excel without cycling through all with Ctrl+PgUp/PgDn?
2
votes
6
answers
31k
views
How to capitalize the first letter in a cell in Excel
Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel?
For E.g Consider the below image :
After conversion it should ...