4
votes
Excel: how to undo in current file only?
You can run each Excel document in a new instance.
Open Excel itself in a new instance
For Excel's main shortcut you could simply add a /x flag after the address in the shortcut's Target field:
"...
3
votes
Accepted
All Borders equivalent in Excel for a range
I don't know a more efficient way than this.
With Range("A1:R780")
.Borders(xlInsideVertical).LineStyle = xlContinuous
.Borders(xlInsideHorizontal).LineStyle = xlContinuous
.BorderAround ...
2
votes
Excel: how to undo in current file only?
If you want to edit two existing XLSX files with two separated histories, there is a work-around, which works - well, mostly...
The first XLSX file you open from its location.
For the second XLSX ...
2
votes
Accepted
Macro name being changed in Excel
I found the solution by chance.
The problem occurs only if the Module name is identical to the Macro name. So the Module has to be named differently. That's it!
2
votes
De-pivot excel spreadsheet
Okay I answered this question 6 years after it is asked... And I am using Excel 2013 now. As far as I understand, this method should apply to Excel 2007, 2010, 2013. Not sure if it works in Excel ...
2
votes
Cells not updating automatically
It looks like it is a "known bug" going on at least since 2012, given google results: once you open one file where the "automatic calculation" flag is set to off, all subsequent workbooks you will ...
2
votes
Cells not updating automatically
Reposting this snippet that user RFB had (inappropriately) attempted to edit into my answer:
A possible cause is that the Office Prefs file is corrupted. In OSX this can be found in:
Library/Group ...
Community wiki
2
votes
Is it possibile to enter dates from a drop-down calendar?
There is number of ways:
adding form field with dropdown calendar can be more comfortable, but suitable for limited cell count made manually.
enable Developer tab in Excel
select Insert > others (...
2
votes
Move to end of selection in MS Excel (2003)
Jumping corner-to-corner inside the selected range:
Ctrl+.
https://www.excelcampus.com/keyboard-shortcuts/jump-to-last-cell-selected-range/
2
votes
Accepted
How can I open a specific sheet named after a month?
To automatically bring the current month's tab to the foreground after opening a workbook, you can simply use this:
Private Sub Workbook_Open()
Sheets(Format(Now(), "mmmm")).Select
End Sub
NOTE: ...
2
votes
Need excel function to filter alpha characters
You can use the Advanced Filter with a Formula for a criteria
The formula must return TRUE or FALSE. This returns TRUE if there are no digits within the word:
Formula: =MIN(FIND({0;1;2;3;4;5;6;7;8;...
2
votes
Accepted
Joining 3 Excel IF Statements
I'm assuming that you want "Miss Window", "Hit", or "Not Scheduled" to show up in a single field.
If I2 Is NOT Empty (True = Next IF)
If I2<E2 - (True = Miss Window / False = Next IF)
If I2>...
2
votes
Accepted
How do I add 1 month to a specific date once that date has passed?
You're in luck, no VBA required. In fact, there is an even simpler approach that doesn't require an IF test:
=DATE(YEAR(NOW()),MONTH(NOW())+(DAY(NOW())>2),2)
I hard-coded the 2nd day of the ...
2
votes
How do I force a user to use a specific format when entering time data?
Old Post, but this may help some searching Google (also I'm not an Excel expert)
Format the Cell as Text with a custom format 00\:00
This will allow users to enter a military time into the cell ...
1
vote
How to insert a line break in a concatenated cell in Excel 2003
The trick is to use char(10) for line return, in combination with clicking on Wrap Text.
Note that you could simplify the formula with TEXTJOIN, like this formula:
=TEXTJOIN(CHAR(10),TRUE,M4:M10)
...
1
vote
Accepted
Calculating the cost of the electricity consumption
To be able to use formula efficiently you need first to calculate "cost correction" which gives you the difference between calculating with constant price (e.g. 370*1) vs based on price categories (e....
1
vote
Fixed cells width and height in Excel 2003
You can use a simple macro,
Sub Macro1()
Cells.Select
Selection.ColumnWidth = 10.75
Selection.RowHeight = 27
End Sub
Just change the height and width to suit your needs.
1
vote
Accepted
Worksheet limit in Excel 2003 (BIFF8)
There is not a harcoded limit.
The limit is related to the memory available in the system.
1
vote
Need excel function to filter alpha characters
A simple way is to use =ISTEXT(somevalue) in a new column and filter for true.
You can do the same with =ISNUMBER, =ISBLANK, etc.
Example:
1
vote
Accepted
In this data set, I want to get the most recent or three most recent numbers for a particular day. How can I get this?
Use this array formula:
=INDEX($C$2:$C$29,MATCH(LARGE(IF($B$2:$B$29=$F$8,$A$2:$A$29),ROW(1:1)),$A$2:$A$29,0))
Being an array formula it must be confirmed with Ctrl-Shift-Enter upon exiting edit mode ...
1
vote
How can I open a specific sheet named after a month?
To get the name of the current month:
Sub tretdc()
tabstr = Format(Now(), "mmmm")
MsgBox tabstr
End Sub
1
vote
Merge two Excel spread sheets using a common column and retaining duplicates
I would create a new ID which is unique, and incorporates the order of the appearance of the IDs. One way to do that would if the first excel starts in A1, so A1 = 'id', then enter in E2:
=A2+COUNTIF(...
1
vote
Adding more than 15 digits in Excel
I had the same issue with barcodes that I was pulling from a database, the solution that worked best for me is to pass the number to excel as a formula that displays text.
For example, instead of ...
1
vote
Highlight birthday in a referenced cell
in cell A1 date of Birth
in cell B1 age with the formula
with the conditional formatting:
=TEXT($B1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0
Having age in B1, are you sure your ...
1
vote
Highlight birthday in a referenced cell
You can add a sheet reference to your conditional formatting formula on sheet 2 to refer to the source cell on sheet 1.
=TEXT(Sheet1!$A1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0
1
vote
Broken ActiveX in Excel 2003
I found that "Forms" provides the same controls. A bit more cumbersome but it works!
Go to View - "Toolbars" - "Forms" and turn on the toolbar. Then select the object from the ribbon.
Gordon
1
vote
Accepted
Why is the maximum row height in Excel 546px?
For the same reason as "640KB is more than enough for anyone!"?
I.e., they probably needed a limit for their view renderer and this was chosen arbitrarily but seemed "big enough" at the time.
By the ...
1
vote
Lost VBA when downgrading from Excel 2013 to Excel 2010
This blogpost helped me in rectifying this error:
https://dynamicsgpland.blogspot.in/2009/11/vba-error-class-not-registered-looking.html
VBA Error: Class not registered. Looking for object with CLSID:...
1
vote
Changing line insert default formatting
Copied this from another forum.
The most easy solution which comes to my mind is to insert an extra hidden row.
So the hidden row will have the correct format you want. Then when you click on ...
1
vote
How to get excel row numbers to skip the header
This formula worked for me. I inserted a new column for A in my spreadsheet, then used this formula in cell A2:
=ROW(2:2)-1
Then I went to "Page Layout" to uncheck View Headings,
as discussed in ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
microsoft-excel-2003 × 277microsoft-excel × 174
worksheet-function × 40
microsoft-excel-2007 × 25
vba × 21
microsoft-excel-2010 × 13
macros × 9
spreadsheet × 9
windows × 8
windows-xp × 7
charts × 7
pivot-table × 7
windows-7 × 6
microsoft-excel-2013 × 5
keyboard-shortcuts × 4
microsoft-office × 4
csv × 3
compatibility × 3
conditional-formatting × 3
sorting × 3
cells × 3
data-validation × 3
microsoft-word-2003 × 3
undo × 3
networking × 2