Feedback by UserVoice

Ryan

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan shared this idea  · 
  2. 3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    You can also add a new window.

    Alt,W,N

  3. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Ryan commented  · 

    F12 has been "save as" since before Excel 2003. It's one key!

  4. 254 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    I find external links by searching the entire workbook for the square bracket [ character. Unfortunately, this finds references to tables as well.

  5. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan shared this idea  · 
  6. 123 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

    Ryan supported this idea  · 
    Ryan commented  · 

    The F4 should loop as follows

    If I refer to a table,
    TableReference --> A1 --> $A$1 --> A$1 --> $A1 --> TableReference

    If I refer to a pivot table,
    GetPivotData --> A1 --> $A$1 --> A$1 --> $A1 --> GetPivotData

    If I refer to a named range,
    Name --> A1 --> $A$1 --> A$1 --> $A1 --> Name

    If I named a cell in a pivot table
    GetPivotData --> Name --> A1 --> $A$1 --> A$1 --> $A1 --> GetPivotData

    Etc.

  7. 125 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    Ryan commented  · 

    Or at least make it visually obvious that a formula has more than what can be seen in the formula bar. When the formula bar wraps, perhaps a tooltip could appear that says "See more".

  8. 259 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Jeffrey for suggesting the shortcut keys to format text as subscript or superscript. I can see that this would be useful and consistent with the other applications. As with all the requests, voting helps move the request up in our priority list, so keep the votes coming if this is important to you.

    Steve K (Microsoft)

    Ryan commented  · 

    I also want subscript and superscript shortcuts, but please don't break Ctrl + for inserting rows, columns, and cells. I use it 50 times a day.

    Ctrl Plus should make a superscript ONLY when I am editing a formula or text. Ctrl Minus or Ctrl Shift Plus should make a subscript when I am editing text.

  9. 45 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Malcom. We’ll keep an eye on this – we’ll be more deeply investigating things with more votes, so people should up vote this if they like it. I’d also encourage people to chime in on the comments for this one with any specific asks for particular cases/operations they care about more than others.

    Cheers,
    John [MS XL]

    Ryan commented  · 

    I will often make a worksheet with nothing on it but a single huge text box, and I write lots of notes in it.

    Ryan supported this idea  · 
    Ryan commented  · 

    It would be super cool if I could embed a Word document as a shape in a worksheet, with all the power and flexibility of MS Word. Styles, headers, chaptering, bullet and numbered lists, tab control. etc.

    It would also be cool if I could add a publisher slide as a shape in a worksheet.

    A chart can exist as an independent sheet, or as a shape within a different worksheet. Why can't I add an embedded worksheet to a different worksheet as a shape. It could make multi sheet formulas way easier to write or audit. in Sheet 1, I have a formula that refers to Sheet1, Sheet2, and Sheet3. I could move Sheet2 and Sheet3 to Sheet1 as shapes. Then when I write the formula in Sheet1, I could see color boxes in each of the three sheets showing me what the formula is doing. If I press "trace precedents", Arrows would point to each of the sheets instead of showing that useless arrow to nowhere.

    Ryan commented  · 

    Excel already has a solution for this. It is called a text box.

    Text boxes can hold hundreds of words. You can use them just like cell comments, but the text box gives you some different flexibility. The text box supports word wrapping and text formatting. Some people try to add documentation by merging several cells, or by writing documentation across several rows with manual word wrapping. Text boxes are far superior to both these solutions.

    Here is how...

    Insert -> Text Box

    Alternatively, you can draw a shape and write on it.
    Insert -> Shapes -> select a box, circle, oval, arrow, or any other shape.
    Draw the shape.
    select the shape.
    Start typing.
    The shape is now a memo embedded in your workbook.

  10. 14 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    In Access, you can make a form for data entry. You can design the form to lay the record out in a way that is more natural than a single line record. This might be your solution for Access.

    Now that I have read your post, I want Excel to have forms that can be used to enter data into a table. Then the table could be summarized with a pivot.

  11. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    I often run into situations like this. There is a good solution if row 11 does not have data. Suppose you have data in each cell of A1:A10, B1:B10, and C1:C10. Further suppose row 11 has no data. Practice this key combo twice daily for a week. After that, you will look like a concert piano player playing beautiful music in Excel.

    Select A1
    Press and hold Ctrl and Shift with left hand
    Tap the down arrow with right hand
    A1:A10 is now selected.

    let go of Ctrl-Shift
    tap right arrow with right hand
    B1 is now selected
    Press and hold Ctrl and Shift with left hand
    Tap the down arrow with right hand
    B1:B10 is now selected.

    let go of Ctrl-Shift
    tap right arrow with right hand
    C1 is now selected
    Press and hold Ctrl and Shift with left hand
    Tap the down arrow with right hand
    C1:C10 is now selected.

    Again, if you have data in row 11, then my solution is garbage for you. Good luck!

  12. 31 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback. This is an interesting idea that we’ll consider for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Ryan commented  · 

    One option on the tooltip could be "Select data". If a series is selected, then the "Select data" button would cause the chart to lose focus, and the cells on the worksheet that contain that series would be selected.

    But if only one point were selected, then the "Select data" button would cause the chart to lose focus, and only the cells on the worksheet that define that point would be selected.

    This would make it way easier to investigate outliers.

    Ryan commented  · 

    I agree. I will often look at a chart with hundreds of points, and I will see one outlier, and I want to know more about that point. It would be nice to see more than just the x,y values. At a minimum, I would want to know the row and column on the worksheet where the x and y are stored. This will help me investigate what makes it an outlier.

    Ryan supported this idea  · 
  13. 19 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    When you insert a column, row, or cell (shift cells down), or cell (shift cells right), Excel gives you an insert options drop down menu next to the range you just inserted. I think they call it a tooltip or something like that. Simply use that menu and select "Clear Formatting".

  14. 6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    I agree with Kenneth. Sometimes I want to write 5*5 and I want it to be a string.

    I would get very frustrated if Excel interpreted 0-5 as a formula. I already get frustrated when it thinks 6-15 is June 15th. How would you enter the following data? You would have to use lots of single quotes.

    Age ..........Cost of
    Range ......Donkey Ride
    0-5 ......... $2
    6-15 ..........$10
    16-50 ....... $15
    51+ ...........FREE

  15. 15 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan commented  · 

    Insert a text box. Text boxes support word wrapping and text formatting. I will often draw a rectangle, and add text to it. Writing on shapes is good because you can have more than one on a sheet. You can also draw arrows from the text box to cells to point things out.

    Although it might be cool to add more word processor features to the text boxes, such as bullet lists, auto-number lists, tab controlling, 1st, 2nd, and 3rd level headers, styles, etc.

Feedback and Knowledge Base