Skip to main content
teylyn's user avatar
teylyn's user avatar
teylyn's user avatar
teylyn
  • Member for 12 years, 7 months
  • Last seen this week
58 votes

What is the significance of the number of columns (16384) in MS Excel 2016?

56 votes
Accepted

Why use CONCATENATE vs & in Excel?

43 votes
Accepted

Reference a cell of the previous row in the same table in Excel?

35 votes

How do I get the =LEFT function in excel, to also take the number zero as the first number?

34 votes
Accepted

Excel auto fill a column with increment

28 votes
Accepted

Fill a large range with a formula in Excel, without mouse-dragging to extend

28 votes

Why do Excel RANDBETWEEN numbers change for any operation on worksheet?

23 votes

In Excel, how do you auto fill until next value?

21 votes

Rewriting a formula of multiple nested IFs that is too deep

20 votes
Accepted

Where can I find the grammar guide for Excel format syntax?

17 votes
Accepted

How can I create a floating text box in excel that contains data from a worksheet?

14 votes

Downloading a local copy of One Note from Office 365 Online

13 votes
Accepted

@ in the beginning of a formula

12 votes
Accepted

put an equation object in an excel cell?

11 votes

Calculate number of Sundays in the month

11 votes
Accepted

Reduce array size in Excel

10 votes
Accepted

Advanced Chart in Excel - column width based on cell value

10 votes

How do I load external images into Excel?

10 votes
Accepted

Word 365 / Word Online -- Insert Table of Contents disabled, how to insert a TOC?

9 votes
Accepted

Convert Word Outline to Excel Columns

8 votes
Accepted

Excel returns #DIV/0! for simple AVERAGE calculation

8 votes

How to bring to front a series in a scattered chart

8 votes
Accepted

VBA macros "deleted" after closing excel file

8 votes
Accepted

Trigger macro with ONE click on specific cell

7 votes
Accepted

Excel format to only prepend character, without changing number format

7 votes

How to add padding to images/chart in MS Word with 'in line with text' wrapping?

7 votes
Accepted

Highlight the cell if greater than value in the next column

7 votes
Accepted

Is it possible to use Power Query editor and Excel side by side

7 votes
Accepted

Why is Outlook Formatting this Column Header into text wrapped (2 lines) when pasting from Excel and how can I stop it?

6 votes

Time Format in Excel (:) not appearing

1
2 3 4 5
33