Get started with Excel, find Featured training, Support and more

[cuong]

Whether you're new to Excel or looking to take your Excel skills to the next level, check out our Excel help center to Get started, find Featured training, Support and more.

Cuong

Microsoft

[#2]

When I use Ctrl+Shift+; (semicolon) to obtain the time, I can format it to include seconds (e.g. hh:mm:ss, but the seconds are always zero. The system clock shows them increasing. How do I get that?

[#3]

@Gumble_1943 

That's with macro https://excelribbon.tips.net/T010635_Inserting_the_Current_Time_with_Seconds

[#4]

Charging a yearly fee for Office is like endless insurance payments. When Office was offered a 1 time price, it was awesome. I tried the annual rate 1 time and quit. Time flies, meaning after 5 years, the costs is $500 or more. Ugh.

[#5]

@Chashot Check out this article aka.ms/AA5ohgi.  Hope that helps.  Cuong @ Microsoft

[#6]

I would like to ask a question, I am writing a program in vba and used the protect command to protect the spreadsheet. What command do I use to protect the workbook?

[#7]

@opeixoto See https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.protect.  Hope that helps.  Cuong @ Microsoft

[#8]

this sounds good! how do i join? I am new to excel

[#9]

Looks like you've already joined the community. Welcome! Let me know if there's anything else we can help with.

Cuong, Microsoft

[#10]

In an Excel Sheet, how can text in a cell automatically overflow into the cells below, if they are empty?

[#11]

@balayla , that's a separate topic, better if you go on https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral and Start new conversation.

As variant you may merge cells, but that's not recommended since you may have negative impact on your other operations.

[#12]

Thanks Sergei, that was the community I was looking for. Merging cells does not help me in this particular case.

[#13]

@balayla 

I see. Without merging that's VBA macro which split and move text (but you shall to define the logic for it, e.g. on every space, every Nth character, etc). But that's not exactly automatic overflow.

Or TextBox.

[#14]

@Gumble_1943 Ctrl+Shift+: enters a static time stamp. If you want something that will update, you can use =NOW() and format as desired. Whenever Excel calculates, the formula will update.

Hope that's what you're after...

[#15]

@cuong 

Good evening!
Thank you for receiving me in the press releases.
I have a problem and please help me if you can!
How can I do if the percentage in A1 is = 100% B2 to be copied to Sheet2?
Thank you!

[#16]

@Cristi1974 You'll need VBA for that. How is the value in A1 changing? If it's due to a formula, then you can use the Worksheet Calculate event. If it's due to a manual entry, then you can use the Worksheet Change event.

[#17]

Hello Sir,

Is there a function for title changing while scrolling up and down on a spreadsheet where the title covers a group in view?

@cuong 

[#18]

@TantalumMan If you can format your "groups" as tables, then the column headers will convert to your table headers once you scroll past the table header row.

[#19]

@cuong  Excel bazen kafa karıştırıcı olabiliyor sizce neler yapmalıyım ? Daha pratik hala nasıl getirebilirim her anlamda . Teşekkürler 

[#20]

Hi @jigsav 

Would you please share some additional context?

Thanks,

Cuong

Microsoft