Home Excel

Excel

104 Conversations

Latest Activity

Custom List Message Item

Hi,

 

Trying to autofill sequential dates in excel, despite altering how the series is filled, I still have the same results.

 

Clicking and dragging increases the year rather than date:

 

MONTUEWEDTHUFRISATSUN
27/2/201727/2/201827/2/201927/2/202027/2/202127/2/2
... Read More
80 Views
11 Replies
Hi There, I see the smart tag, the options I have there are: copy cells / fill series / fill formatting only / fill without formatting None of these give the desired resu... Read More

Hello Ben

 

When you release the mouse after filling the cells a smart tag appears with further options.

 

Hello,

 

I'm in need for your help. At the moment, I'm trying to make a file with the whole years planning. So far so good, but I've stumbled upon a problem. I hope you can help me.

 

What I need is:

 

A manner (probably VBA) that allows me to automatically cha

... Read More
191 Views
22 Replies

If you use conditional formatting instead of manually changing the cell color, then you can apply the same conditional formatting rule to other cells on other tabs. 

 

Colo

... Read More

Jonathan, if your tabs are really identical you may select them (not data areas, but tabs itself) and work with them as with one tab. All your changes, includes colors, w

... Read More

hi. 

 

ive tried google for answers and just getting confused! i am creating a spreadsheet in which there is a specific column i want to track the changes of by time/date stamp. ie, data goes into column E (Say cell 12) and the 'Last modified date" would ap

... Read More
19 Views
1 Reply

Hi Jake,

 

Paste in your code on last time and then Save-as the file and select the file type Excel Macro-Enabled Workbook (xlsm).

 

Hi everybody!

I'm new here I would like to convert a table that is in form of picture in a table of excel for make editions. Is it possible?
Have a great day!

64 Views
4 Replies

Hello Adriana, if you mean you want to be able to edit an Excel table that was created as a picture, I am assuming it was initially created as a table in Excel, copied an

... Read More

Hi Adriana,

 

When you say it is a picture do you mean a .jpg file ?

 

 

Hi, 

I have Excel 2007 and I want to create a master work book with lots of separate work sheets. 

I want to be able to set it up so that if I change info OR ADD a line that it will feed through to three other work books which are cut down versions of the m

... Read More
111 Views
8 Replies

OK, I have worked out myself how to establish the link between the source workbook and the target workbook. 

So now I just need to know if I can add a line in the source w

... Read More

Hello,

 

In an excel worksheet I made one object by adding 3 standard objects from the shapes list. How can I group these so I can enlarge/reduce the total object in size, copy it, move it, etc.?  I see the 'grouping button' in the group 'sorting' in the su

... Read More
18 Views
1 Reply

Hi Peter,

 

If you select all you three shapes (using Ctrl and click on each of it) Group menu shall work. Is it grayed in your case with the selected shapes?

Read More

Hi,

 

Perhaps a good idea to suggest this at excel.uservoice.com, Microsoft actively monitors that site for product improvement suggestions.

Read More

Some of our users have reported that they are no longer able to create Excel Surveys from within Excel Online. I've spot verified that the option does appear to be missing. I'm searching to see if this has been deprecated. Attached represents what we use

... Read More
12 Views
0 Reply

Can someone tell us what is the biggest number in Excel?
I have read some articles about this topic, some people say that this number is the biggest:
9.99999999999999E+307

34 Views
1 Reply

I have a file that I need to have all the asset numbers be preceded with an L.  How can I change all the numbers?  Example 0120170004 to L0120170004.

28 Views
1 Reply

Hi Linda,

 

Depends on how you 'numbers' are formatted within the Excel. To transform from A1 cell

If the cell is in text format text when

="L" & A1

If in number format when

=T
... Read More

I am at a center where we have mail call for clients.  Moving from a blackboard I can see a monitor displaying an excel alphabetical list that scrolls automatically and loops through the names during the day.  Typically 200 clients have mail so the displa

... Read More
30 Views
0 Reply

Hi,

 

if I add a new worksheet the cell format for all cells by default is time. This means, when I type a number e.g. "0" it will be displayed as 00:00:00

Searching the internet didn't bring a solution.

Once I remember I read about a bug with a certain hotke

... Read More
36 Views
2 Replies

Hi @Christoph Damoser

 

I wrote this short article explaining how to set a template to open up automatically each time you start Excel.

 

https://www.linkedin.com/pulse/start-excel-your-way-every-day-60-second-tip-wyn-hopkins

... Read More

Hello Christoph

 

Check you cell styles.

 

Read More

Hello! I suggest removing the Symbols menu (equations) permanently from Excel as this would make it look more "natural", since the application's emphasis is data analysis.

43 Views
1 Reply

Hello,

 

you can post suggestions for improvements to Excel at this site: http://excel.uservoice.com

 

People can vote on suggestions and Microsoft will be more likely to wor

... Read More

After downloading the MS Excel app AND getting Microsoft 365 I still cannot open hyperlinks on my Android tablet. I've googled for hours and still camme up short, any suggestions are welcomed!!

47 Views
0 Reply

Hello everyone,

 

Sorry if this is a topic that's ben done to death but I've had a look and I can't see anything really.

 

We've just moved our users to 365 after a short pilot phase. The biggest problem our users are having (apart from Outlook attachments, d

... Read More
209 Views
8 Replies

Hi all,

 

Just thought I'd update where we are with this as it's proving a big issue.

 

The story was already unclear re pinning, but a recent update to Office seems to speci

... Read More