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.

Filter by
Sorted by
Tagged with
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 ...

1
137 138
139
140 141
518