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.

learn more…| top users | synonyms (2)

1
vote
0answers
10 views

Can Excel automatically convert an entry into a clickable link inside the same workbook?

Please let me better clarify my question. What I would like to do is the following:1) Have a workbook with, say, 100 worksheets2) Each worksheet has a different tab name3) Each worksheet ...
-4
votes
1answer
20 views

I want to put the amount I owe in one column and the amount I pay down another and have the amount I owe reduce every payment [on hold]

I want to put the amount I owe in one column and the amount I pay down another and have the amount I owe reduce by that amount each payment. Each payment being different amounts.
0
votes
0answers
6 views

Apply condition to processRange function below

I have code below that checks to see if column "NamedRange" in the table attached appears as a named range in the (dstRng) template and if it does exist it returns the value to the right ("report ...
-1
votes
0answers
18 views

Duplicate sheets while retaining and updating incremental formatting in cells

Last year I built and formatted 52 tabs (sheets) names 'Wk1, Return1''Wk2, Return2' both up to wk52 and Return52. There is a lot of formatting in individual cells within these sheets. Wk2 takes data ...
0
votes
0answers
13 views

How to add an existing Excel userform & VBA to new spreadsheet (For Dummies)

I have an end user who exports data from an accounting program and each time they export and create a new spreadsheet, they need to add a userform and VBA file. Below are the instructions I have ...
1
vote
0answers
12 views

Excel—insert underline to separate weeks

I have an excel worksheet with a column of deadlines. My project managers want an underline added to the last row in a given week to visually separate between weeks. How can I do this without having ...
2
votes
1answer
12 views

Excel 2010 line chart - how to have the x axis show mmm format (e.g. Jan Feb etc)

I have a table of data, with one row for each day of the year (1/1/2018 through to 31/12/2018). I want to show this on a line chart with the x axis labelled with the short text format of the dates, so ...
-3
votes
1answer
31 views

Limits of creating a database with Excell [on hold]

I'm creating a in-house database to track the progression of multiples files. An Excel sheet should be enough for our current needs, but I have three quesitons regarding Excel limits:is it possible ...
1
vote
2answers
20 views

Excel how to deactivate “Most Recently used function” suggestion from drop down list

I am currently using Office 365 on Mac.For the "Drop-down Function-suggestion list", Excel have started suggesting the "most recently used" function, as opposed to JUST suggesting it in alphabetical ...
0
votes
2answers
42 views

Excel VBA Replace endless case statements with better alternative

I am populating a combobox with a row in the worksheet, then when picking that item in the combobox i want it to hide or unhide that row. It works with my case statements, but how can i do this ...
-1
votes
0answers
13 views

Paste Link Image - Misaligned

I am testing a dashboard with co-workers and noticed about 50% of the time the linked image comes out incorrect. Let's say I copy a table from D5:F5, sometimes it works fine, sometimes it displays ...
1
vote
1answer
24 views

Microsoft Excel mirror

I have 2 sheets in the same workbook containing the same values. I want the Sheets to mirror each other so that whenever I choose a new value in either sheet 1 or sheet 2, the value on the other sheet ...
1
vote
0answers
12 views

Student voting system in Excel: Combination Slicer and Histogram

I am trying to create an interactive chart with an Excel workbook (2016) to display the results of student voting. My workbook has several columns, but the two relevant here are "student name" and "...
0
votes
1answer
12 views

Count values depending on Equality Compare

I have a tables that looks like the following:I have multiple Item rows, and for each there are many Value columns, and a single Result. What I would like to do in my TOTAL is, for each Value column,...
0
votes
2answers
60 views

How to ask excel to do sequenced formulas in single cell

Here have some information in cell A1.Then cell B1 has a formula (called "Formula1") to modify A1, resulting in B1 value.Then cell C1 has a formula (called "Formula2") to modify B1 whose value was ...

153050per page