Questions tagged [microsoft-excel]
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.
25,878
questions
0
votes
0
answers
2k
views
Auto-populate a cell based on text input of one cell and the presence of text in another cell
I'm trying to reduce the amount of manual input on a Drawing Log I'm presently creating.
Basically, I've got 5 columns: Drawing No., Client, Project, Date, and Description (in that order, though Date ...
0
votes
1
answer
11k
views
Microsoft Excel TIME related Conditional Formatting
I'm maintaining an attendance table in the following format.
01 Wed IN | 01 Wed OUT
==========|===========
08:27 | 17:16
08:36 | 14:31
08:38 | 17:07
08:32 | 17:05
08:47 | 17:05
...
0
votes
1
answer
6k
views
How to customize Paste Value Excel Short Cut
I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...
1
vote
1
answer
917
views
.bat/.vbs script runs manually, but not from task scheduler
I have set up a task in task manager that calls a single .bat file (which then calls a .vbs) to tackle 4 easy steps:
.bat file:
Step 1: Grabs a handful of .xlsx files from over the network and copies ...
0
votes
1
answer
1k
views
Total for stacked area chart
On a stacked area graph, is there any way to display what the total of all the series are for the last data point other than eyeballing that it looks somewhere around 115 in the example below?
I know ...
0
votes
1
answer
450
views
Make second column mandatory if the first one has value in excel
I have two columns. The first one is a drop down containing 'yes' and 'no'. The second column becomes mandatory if there is a value in the first column only.
Please guide how do I do that ?
I want to ...
0
votes
1
answer
597
views
Mail Merge - Adding space for response
I am working on a word document into which we are merging excel data. We need to have either a line or some space when a field is blank. The merged form will be distributed for members to review the ...
5
votes
2
answers
21k
views
Setting the content language of cells in Excel
In MS Excel, is it possible to set the content language of cells e.g. per column? The purpose would be, among other things, to make proper spelling checks when the content is multilingual (e.g., a ...
0
votes
2
answers
189
views
Using a drop down list to populate values in another column
In Column A I have a dropdown list of numbers ranging from 0-10. This is the census. In Column B I would like it to populate with the number of staff I need based on the corresponding number on the ...
0
votes
1
answer
360
views
In Excel, fiscal year from date not working
In Excel 2016, I am trying to display the fiscal year in a column next to one with the date of an appointment. The dates are formatted as "short date". The fiscal year runs 10/01/2019 ...
0
votes
2
answers
519
views
Excel SUMIF account currency matches the one being counted
This is related to a previous question I asked. There, I made the mistake of oversimplifying in the example I used.
In contrast to that example, where each account balance appears once and in order, ...
2
votes
3
answers
4k
views
How to categorize text data based on a value in a column?
I am using Excel to generate a list of people working in the company containing information about the employees relevant for our department.
The spreadsheet looks generally like this (fictive data):
...
2
votes
2
answers
3k
views
Excel, use conditional formatting to highlight dates in current fiscal year?
In Excel 2016, I'm trying to use conditional formatting to highlight dates in a current fiscal year, but I can't figure out how to write the formula correctly. The fiscal year goes from 10/01/19 to 09/...
0
votes
0
answers
68
views
Excel 2013 Pivot Chart: wrong day-count on y-axis
I'm making this pivot-chart where the orange series shows the average count of days (gg) with hh:mm:ss part.
Now, as you can see on the picture the pop-up shows the correct value (00gg 23:53:37), but ...
0
votes
0
answers
96
views
Freeze multiple rows in excel
Is it possible to freeze multiple rows at same time (say 1, 25 and 50). i.e. 1st row is freeze, when I continue scrolling 25th row also freeze below 1st row, and continue to scroll ahead from 26th row ...
0
votes
2
answers
81
views
Excel SUMIF VLOOKUP matches value
I have data as follows:
What I want is to fill out the Total cells for each currency by adding up each Balance cell for which the currency of the account (above) matches that currency. So in this ...
0
votes
2
answers
38
views
Function that writes name depending on two conditions
I would like to know how to implement this in an excel formula: I have a column with some names, a row with different numbers (dates), and the remaining values work as "keys". For instance:
...
0
votes
1
answer
81
views
If function with multiple inputs that returns text strings with variable
Essentially I have 4 columns of values I'm pulling from.
A: "Old # of Cards"
B: "Old Std Pack Qty"
C: "New # of Cards"
D: "New Std Pack Qty"
In a separate ...
1
vote
1
answer
404
views
How do I fill a row based on the number of filled columns in the row above?
Here's my current spreadsheet:
Rows 1 and 3 are the input, and I want to fill row 4 automatically based on how many columns there are in row 3. Example end result:
The "discount factor" is ...
0
votes
1
answer
256
views
Object required error in vba
I am trying to run the below macro to enter text in multiple selected sheets. But i get the runtime error "424" Object required
Sub CL_Numbering()
Dim shts As Worksheet
i = 1
For Each shts ...
0
votes
1
answer
110
views
How to add the quantity corresponding to same number in different sheets
Team,
I have the attached sheet where in multiple common materials are used in build up of different equipments.
What I intend to do is to get the sum of Qty of each material required (Col E )ex-...
0
votes
1
answer
305
views
Excel: How to internally store a numerical value in a cell but make it appear differently (Ex. Alphabetical Names)?
For example, I want to name a cell "Win (+5)", but I want it to act like it just has "5" in it so I can use it for functions and etc,.
I couldn't figure out how to do it.
0
votes
3
answers
38k
views
Deleting charts in excel using vba
How to delete all charts in Excel Workbooks using VBA.
ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.Parent.Delete
0
votes
1
answer
96
views
EXCEL: How do I extract a value from a column corresponding to a partial match?
WORD PROBLEM: I have a list of all biological processes involved in a disease (PROCESS TITLES) (Column A). Column C shows the genes that are commonly expressed in that disease and are a part of that ...
3
votes
3
answers
9k
views
Copy table from Word to Excel Preserving Cell Size
I have a set of Word documents, each document contains a table set up for printing so it prints on one full A4 page. Now I need to copy those tables to Excel, but the copy operation doesn't preserve ...
0
votes
1
answer
722
views
Convert a plain picture into shape in Excel
I am trying to create a chloropeth map consisting of 77 districts within a country in Excel. For that I pulled out individual districts by using photoshop but that's in picture format. The problem ...
0
votes
1
answer
78
views
Coherently Organizing Charges on an Invoice Report
I have a terrible invoicing report that breaks surcharges down just like this:
My desired output (open to suggestions if there's something more intelligent) is one where I can see the transaction ...
0
votes
1
answer
163
views
How can I scroll using the mouse pad while editing a formula in Excel Professional Plus 2010?
How can I scroll using the mouse pad while editing a formula in Excel Professional Plus 2010 ?
Before I could press F2 and (while in editing mode) I could quickly use 2 fingers on the mouse pad area ...
0
votes
4
answers
6k
views
Excel: drag row to a new position and automatically insert/remove
I spend a lot of time moving rows around in Excel, both on the Mac and on Windows. I would like to easily drag an excel row into a new position on a spreadsheet and have the spreadsheet insert the row ...
0
votes
0
answers
2k
views
Excel taking 30+ seconds to open any file on a network share
1 client of ours is having this issue where any file opened in excel, over the network will take 30-60 seconds to open
This issue has been troubleshot for over 20 hours now, so if I miss listing some ...
0
votes
1
answer
2k
views
Excel - calculating difference between all cells in a column
I am looking to calculate difference between set of a data in a column for every row on an excel spreadsheet. A table/matrix would ordinarily be the best way of achieving that where i create a column ...
1
vote
1
answer
40
views
Can Excel autofill one range but copy another in the same autofill operation?
I have a table in Excel which I need to copy 80 times, and have each one be numbered sequentially.
(Table 1, Table 2, Table 3 ... Table 80)
However, one of the columns in this table contains the text (...
0
votes
0
answers
49
views
Inputting a cell address in a formula
so I'm in Sheet1 of a workbook and i'm trying to set up a formula where the end result is 'Sheet2'!$B:$B.
I'm doing this so that i can use that result as an input for an Index Match formula. Any ideas?...
1
vote
1
answer
139
views
Mac-Excel Conditional Formatting with 8 variables, any 2 combined variables give 2 outcomes
MacOS Catalina,
MS Excel 16.40
I have a question, if anyone can help...(changed the request a bit because as I have been trying to do this myself, I couldn't get my head around it.
I have 8 variables. ...
0
votes
1
answer
254
views
How to reduce multiple tables with different data into a master table (with at least one association)
Lets say that I have have 5 tables, all residing in different sheets.
The tables all contain at least one dimension that can be associated with any other table.
Some of the tables will share multiple, ...
0
votes
2
answers
291
views
How to conditionally concatenate a range with VBA?
In my work, every end of the month I have to review data saved in spreadsheets like the image. The only data that interests me is to check the value of L column and obtain the data in the BS column. ...
0
votes
1
answer
136
views
In excel, how do I turn transpose the whole row after a certain row element while stacking them into one big column?
Here is an example of what I want to do.
Area Y M D1 D2 D3 D3 D5 D6
Barisal 1953 11 0 0 4 16 0 2
Barisal 1953 12 35 14 9 0 0 0
Barisal 1954 1 0 1 16 ...
0
votes
1
answer
165
views
Why does conditional formating "white out" only certain manual formating is some cells?
I'm trying to make a spreadsheet with tables, with some automation, that keeps track of my work hours. (Note I'm not using the Excel "format as table" feature. This is all by hand). ...
0
votes
1
answer
175
views
Excel unstacking data into multiple columns
I am struggling with unstacking, there are many easy Power Query and Pivot solutions , however i would like to have the solution in formula's so people understand the power of formulas.
Marketing, PR, ...
0
votes
1
answer
103
views
showing error when use loop in vba
I have a code that's first job is to find "Qty" and "Fty" word in P column. Then it will get the row number of that row. The code was running smoothly.
But now when I added a loop ...
12
votes
3
answers
64k
views
How can header cells in Excel be "pinned" or "frozen"? [duplicate]
How can you "pin" or "freeze" cells in the top row and/or leftmost column of an MS Excel sheet, so that they always remain visible regardless of scrolling?
7
votes
3
answers
67k
views
How to keep part of a spreadsheet always visible during navigation
I want to apologize in advance for asking something that's clearly available on the web. Unfortunately, I don't know the appropriate terminology though.
I'm looking to keep certain rows/columns ...
1
vote
1
answer
23k
views
Unable to add comments in Microsoft Excel
I was able to add comments in one of my excel files, by right clicking the target cell and then selecting add comment. However suddenly add comment option disappeared from the right click menu and ...
3
votes
1
answer
1k
views
excel vba: to export multiple excel sheet into its designated jpg file
I am working on an excel vba command to export multiple excel sheet to its designated jpg file.
I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format.
...
1
vote
0
answers
121
views
In a spreadsheet, can you force pasting from the system clipboard?
I've noticed what seems to be new behavior the past several months in a few spreadsheets on Windows 10.
Actions Taken:
Select and Copy a cell in a spreadsheet.
Observed in Windows 10 / Microsoft ...
0
votes
1
answer
800
views
Sorting by prefix and suffix in Excel
So I have a list of values in an Excel table (that's important, as I want to keep the functionality of the table) that are like this:
A/1
A/2
A/6
A/11
A125
B/1
B/2
B/3
B/4
B/10
B/11
B/38
B/110
When ...
0
votes
1
answer
2k
views
How to include only specific columns as axis categories from an Excel Table
I am familiar with Excel Tables, Pivot and so on.. but one tricky thing, how can I hide a column in the Table and also have that column not used as a category in my chart?
Excel has a solution by ...
-1
votes
1
answer
66
views
if function don't checks else if statement
I have a code that if my targeted cells value is nothing I mean empty then it will jump to the skip line. And if the targeted cells value is not empty then the code will run.
Here is the code :
...
0
votes
0
answers
718
views
Excel: Fake Blank Cell (cell has no content, nothing in the function box, but not recognized as a blank cell)
I have an Excel file with plenty of "blank" cells, these cells are not showing any content in the cell itself nor in the function box. And I'm trying to replace all these "blank" ...
0
votes
2
answers
118
views
identify the inside range of two cell reference
I want to create something like this.
There will be two cell. one for input one cell reference and another for another cell reference.
example : What is the range inside cell A1 and A10?
The answer is ...