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: "...
Reza Nooralizadeh's user avatar
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 ...
damik_'s user avatar
  • 46
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 ...
gloschtla's user avatar
  • 111
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!
Arnold's user avatar
  • 36
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 ...
Kenneth L's user avatar
  • 14k
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 ...
jumpjack's user avatar
  • 425
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 ...
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 (...
miroxlav's user avatar
  • 13.5k
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/
Muhammad Salman Nasim's user avatar
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: ...
Leviathan's user avatar
  • 199
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;...
Ron Rosenfeld's user avatar
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>...
Keypunch's user avatar
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 ...
fixer1234's user avatar
  • 27.5k
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 ...
OverStacked's user avatar
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) ...
Jean-Francois T.'s user avatar
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....
Máté Juhász's user avatar
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.
PeterH's user avatar
  • 7,435
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.
jcbermu's user avatar
  • 17.5k
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:
TEEBEE's user avatar
  • 11
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 ...
Scott Craner's user avatar
  • 23.2k
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
Gary's Student's user avatar
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(...
Spencer Ogden's user avatar
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 ...
Mar Yo's user avatar
  • 11
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 ...
Máté Juhász's user avatar
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
SincereApathy's user avatar
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
Gordon Marney's user avatar
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 ...
Atlant Schmidt's user avatar
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:...
KawaiKx's user avatar
  • 1,153
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 ...
Jose Martinez's user avatar
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 ...
Bill Cooksey's user avatar

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