Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
Results tagged with microsoft-excel
Search options not deleted
user 2293
A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
0
votes
1
answer
131
views
Does excel have a csv lint function?
Does Excel have a csv lint function that will check to see if your file adheres to RFC4180?
Or does Microsoft just not include functionality like this on purpose?
0
votes
1
answer
42
views
Is there a back / forward functionality in excel, that lets you go back and foward between c...
I want to be able to jump back and forth between cells that I've either edited or typed in the Name Box.
I've added the forward and backward buttons to the quick access toolbar, but they only work whe …
0
votes
0
answers
74
views
Excel equivalent keyboard shortcut to CTRL+D for filling in columns selected columns with th...
I don't always use Excel, but when I do, I find the need to fill duplicate values between columns that I have selected and not just values below the currently selected cell.
Is there an equivalent key …
0
votes
0
answers
30
views
Does # in an excel formula move you to the last cell in the dataset?
I have a # in my formula and it showed up because I hit CTRL+DOWN when selecting to move to the last cell in the dataset.
Is that what it represents?
For example $A$1# would take you to the last recor …
0
votes
0
answers
43
views
Excel 2019 shared (Legacy) spreadsheet user has mutually exclusive access for some reason?
There's a shared spreadsheet, stored on a mapped drive at work that users work on all at the same time, but when one of the users logs into it the rest are kicked out.
Is there a setting that causes …
0
votes
0
answers
40
views
What is the name of the range of cells that are actually loaded into memory in Excel?
I keep thinking it's called Visible Range but I doubt that's actually it.
Basically I'm trying to find out what the cells that are selected when you press CTRL+Left Arrow is called.
1
vote
1
answer
1k
views
Does Excel have Sticky headers that you can freeze the pane like in Bootstrap?
I have a spreadsheet where there are multiple headers and they are like a million lines up the spreadsheet, so when I want to see what category it is in, I have to scroll up for like a million years.. …
0
votes
1
answer
240
views
In Excel is there a keyboard shortcut for jumping back to the last cell edited?
I find myself in Excel a lot editing a cell and then jumping to some other part of the spreadsheet so I can find some information and then scroll all the way back to the cell I was editing. This wast …
0
votes
1
answer
27
views
Naming a range and referring to it in Excel?
Is it possible to put a named range in a formula like this?
=ISNUMBER(MATCH(D42,someworksheet!A:A,0))
Specifically where it says A:A ?
1
vote
1
answer
1k
views
Is there a way to keep the selected row highlighted when the window loses the focus in Excel...
When I'm using Excel 2010, and I have a certain row selected, if I then tab away to another window or sheet, the row/cell that's highlighted is no longer visible. This is really annoying when looking …
0
votes
1
answer
218
views
Does filtering a table in Excel stored in SharePoint Online filter it for all the other peop...
I’ve used earlier versions of Excel where filtering a sheet meant that it would do the same for others on the network with the file open; is the same true of one stored in SharePoint Online?
0
votes
2
answers
102
views
Weird File Attributes in Excel Save Dialog
I vertically re-sized my excel Save As dialog today and found a bunch of strange file attributes that I've never seen in the dialog before. They only appear when the dialog is resized small enough th …
0
votes
1
answer
153
views
Does Acrobat XI Pro Win ESD support fillable form fields from a CSV?
At work I had an old version of Adobe Acrobat Pro, version 9, which I used combined with some Actionscript and batch actions to fill in form fields using a csv file and finally outputting to one pdf f …
0
votes
1
answer
15k
views
How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]
If I press CRTL+Down I move to the cell before the empty cell.
If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell.
Now if I want to auto fill …
0
votes
0
answers
41
views
Can you specify a named-range based on a rule in Excel?
For instance, I have a dataset that has many named ranges in it, but I find that the range gets out of sync when I add rows below it.
If a column a row (for instance, id) starts with a specific number …