Super User Stack Exchange
Super User Stack Exchange

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.

Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications).

Microsoft Excel 2010

Features and usage

The latest version is Excel 2021 for Windows and macOS. Features include calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). A new user-interface design, dubbed the "ribbon", was introduced with Excel 2007 for Windows. A similar UI was introduced to Excel 2011 for OS X.

Excel is the among most widely used spreadsheet programs, especially in business environments. The first version was introduced in 1993, and new versions have been released every 2–3 years since then.

Recent versions

Subscription based license/version

Windows (stand-alone license/version)

Mac (stand-alone license/version)

Other tags

More specific tags include for scripting, for formulas and for pivot tables.

More information

Samples and Tips

25293 questions
4
votes
2 answers

Excel Free Text Survey Analysis

I have to analyze a survey. The survey consists of some yes/no questions, some numeric questions and some questions like the following (free text where respondents have entered multiple answers). Do you have any social networking accounts (Facebook,…
joec
  • 181
  • 2
  • 8
4
votes
1 answer

In Excel, doing a "Freeze Panes" on the right-most column instead of the left-most?

My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s). However, I have a table where a very important column needs to be located on the far-right, because elsewhere I am using…
Steve Perkins
  • 197
  • 1
  • 3
  • 8
4
votes
4 answers

MSFT Excel pivot table links to external data

Question1: What is the best online forum to ask MSFT Excel questions of the following variety? Question2: How can I link an excel pivot-table to a potentially changing source table without having to re-draw the excel pivot-table layout every time…
dreftymac
  • 435
  • 1
  • 8
  • 23
4
votes
2 answers

Pasting to Excel from Word - stop a Word new line being converted into a new cell

So I have a table in MS Word which has two columns. In the second column the text is spread on multiple lines, ie I have pressed 'Enter' to achieve this. When I paste into Excel, it converts these separate lines into separate cells. What I want it…
Sean McRaghty
  • 353
  • 1
  • 4
  • 7
4
votes
1 answer

Is it possible for Excel print consistently with any printer? avoid awkward page breaks?

Our organization has a hundred printer makes and models. We all use Office 2007, and we all print to letter size (8.5" x 11") paper. However, when someone distributes an Excel spreadsheet across our organization, it prints with awkward page breaks…
William C
  • 2,439
  • 5
  • 27
  • 44
4
votes
10 answers

Getting Networkdays to accurately reflect the number of days between two dates

I am using the NETWORKDAYS formula to count days between 2 days for a series of different transaction dates. I want the count to exclude weekends and holidays on each transaction date. However, the result doesn't come out as I expected. For…
user56517
  • 41
  • 1
  • 1
  • 2
4
votes
2 answers

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering projects. Sometimes in Excel I want to manipulate…
NoCatharsis
  • 3,077
  • 12
  • 43
  • 58
4
votes
1 answer

Is is possible to apply separate formatting to multiple different Excel table columns?

I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks like I can create a "table style", but only the…
jtolle
  • 537
  • 2
  • 8
  • 18
4
votes
4 answers

Excel formula to display a string of text and numbers

I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx data1 is in column A and data2 is in column B. the format of data1 needs to be 5 numbers (sometimes beginning with zeros). for data2, they need to type in…
excel gamine
4
votes
4 answers

custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've tried the following with no luck [=0]"Enter…
guitarthrower
  • 983
  • 2
  • 8
  • 15
4
votes
2 answers

Request: Excel equivalent of Google Spreadsheet ARRAYFORMULA + CONTINUE functionality

Google Spreadsheets has a syntax permitting a user to specify an entire row, column, or area with a formula in a single cell. For example, entering ... =ARRAYFORMULA(ROW(A3:A6)) ... into cell C1 creates ... C 1 3 2 4 3 5 4 6 The contents…
Thomas L Holaday
  • 822
  • 4
  • 11
  • 22
4
votes
1 answer

How do I create an Excel Macro to output key/value pairs to file?

I have two columns as key/value pairs and want to export them to a file in the structure key=value (to create a properties file). I tried this script: Sub Properties() Dim FileName As String, i As Integer, str As String FileName =…
jmcmahon
  • 328
  • 3
  • 9
4
votes
8 answers

Is there a custom format in excel to show cents values without a decimal

I would like to display 0.37 as 37¢, in Excel. I can do .37¢ with the format .00¢, but 00¢ doesn't work, cause it works with the whole number part. I know the percentage sign works with the next two digits, like I would like to do, so maybe there is…
apeterson
  • 217
  • 2
  • 4
  • 8
4
votes
3 answers

Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 90,00 106,0 110,00 101,0 125,00 88,0 …
Rook
  • 23,617
  • 32
  • 128
  • 213
4
votes
3 answers

Horizontal scrolling with mouse wheel/keyboard in Excel 2003?

How can I scroll horizontally in Excel 2003 using the mouse wheel with the keyboard? Operating system is Windows XP.
studiohack
  • 13,468
  • 19
  • 88
  • 118
1 2 3
…
99
100