Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-757901%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757901%22%20slang%3D%22en-US%22%3EWhen%20I%20use%20Ctrl%2BShift%2B%3B%20(semicolon)%20to%20obtain%20the%20time%2C%20I%20can%20format%20it%20to%20include%20seconds%20(e.g.%20hh%3Amm%3Ass%2C%20but%20the%20seconds%20are%20always%20zero.%20The%20system%20clock%20shows%20them%20increasing.%20How%20do%20I%20get%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-757932%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377313%22%20target%3D%22_blank%22%3E%40Gumble_1943%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20macro%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT010635_Inserting_the_Current_Time_with_Seconds%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT010635_Inserting_the_Current_Time_with_Seconds%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763912%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763912%22%20slang%3D%22en-US%22%3ECharging%20a%20yearly%20fee%20for%20Office%20is%20like%20endless%20insurance%20payments.%20When%20Office%20was%20offered%20a%201%20time%20price%2C%20it%20was%20awesome.%20I%20tried%20the%20annual%20rate%201%20time%20and%20quit.%20Time%20flies%2C%20meaning%20after%205%20years%2C%20the%20costs%20is%20%24500%20or%20more.%20Ugh.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765023%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765023%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378699%22%20target%3D%22_blank%22%3E%40Chashot%3C%2FA%3E%26nbsp%3BCheck%20out%20this%20article%20%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAA5ohgi%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaka.ms%2FAA5ohgi%3C%2FA%3E%3C%2FSTRONG%3E.%26nbsp%3B%20Hope%20that%20helps.%26nbsp%3B%20Cuong%20%40%26nbsp%3BMicrosoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779307%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779307%22%20slang%3D%22en-US%22%3EI%20would%20like%20to%20ask%20a%20question%2C%20I%20am%20writing%20a%20program%20in%20vba%20and%20used%20the%20protect%20command%20to%20protect%20the%20spreadsheet.%20What%20command%20do%20I%20use%20to%20protect%20the%20workbook%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780609%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384389%22%20target%3D%22_blank%22%3E%40opeixoto%3C%2FA%3E%26nbsp%3BSee%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.workbook.protect%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.workbook.protect%3C%2FA%3E.%26nbsp%3B%20Hope%20that%20helps.%26nbsp%3B%20Cuong%26nbsp%3B%40%20Microsoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787342%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787342%22%20slang%3D%22en-US%22%3Ethis%20sounds%20good!%20how%20do%20i%20join%3F%20I%20am%20new%20to%20excel%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787482%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787482%22%20slang%3D%22en-US%22%3ELooks%20like%20you've%20already%20joined%20the%20community.%20Welcome!%20Let%20me%20know%20if%20there's%20anything%20else%20we%20can%20help%20with.%3CBR%20%2F%3E%3CBR%20%2F%3ECuong%2C%20Microsoft%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797586%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797586%22%20slang%3D%22en-US%22%3EThanks%20Pham%20I%20am%20developing%20a%20small%20project%20for%20my%20office%20to%20maintain%20attendance%20record%20with%20some%20rules%20and%20i%20am%20stuck%20in%2014%20hrs%20rule%20and%208hr%20gap.%20if%20anyone%20can%20help%20will%20be%20much%20appropriated.%20ITs%20a%20Sunday%20to%20Monday%20roster.%20Rules%20for%20excel%3A%20A%20Person%20cannot%20work%20more%20than%2014%20hrs%20a%20day%20not%208%20days%20in%20a%20row%208%20hours%20gap%20in%20between%20the%20shifts%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750691%22%20slang%3D%22en-US%22%3EGet%20started%20with%20Excel%2C%20find%20Featured%20training%2C%20Support%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750691%22%20slang%3D%22en-US%22%3E%3CP%3EWhether%20you're%20new%20to%20Excel%20or%20looking%20to%20take%20your%20Excel%20skills%20to%20the%20next%20level%2C%20check%20out%20our%20%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlhelpcenter%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20help%20center%3C%2FA%3E%3C%2FSTRONG%3Eto%20%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlgetstarted%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGet%20started%3C%2FA%3E%3C%2FSTRONG%3E%2C%20find%20%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlfeaturedtraining%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFeatured%20training%3C%2FA%3E%3C%2FSTRONG%3E%2C%26nbsp%3B%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelAnswers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESupport%3C%2FA%3E%26nbsp%3B%3C%2FSTRONG%3Eand%20more.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-808666%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%2C%20Support%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808666%22%20slang%3D%22en-US%22%3EIn%20an%20Excel%20Sheet%2C%20how%20can%20text%20in%20a%20cell%20automatically%20overflow%20into%20the%20cells%20below%2C%20if%20they%20are%20empty%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-808749%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%2C%20Support%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808749%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393616%22%20target%3D%22_blank%22%3E%40balayla%3C%2FA%3E%26nbsp%3B%2C%20that's%20a%20separate%20topic%2C%20better%20if%20you%20go%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%3C%2FA%3Eand%20Start%20new%20conversation.%3C%2FP%3E%0A%3CP%3EAs%20variant%20you%20may%20merge%20cells%2C%20but%20that's%20not%20recommended%20since%20you%20may%20have%20negative%20impact%20on%20your%20other%20operations.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809301%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%2C%20Support%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809301%22%20slang%3D%22en-US%22%3EThanks%20Sergei%2C%20that%20was%20the%20community%20I%20was%20looking%20for.%20Merging%20cells%20does%20not%20help%20me%20in%20this%20particular%20case.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809369%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%2C%20Support%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809369%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393616%22%20target%3D%22_blank%22%3E%40balayla%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20see.%20Without%20merging%20that's%20VBA%20macro%20which%20split%20and%20move%20text%20(but%20you%20shall%20to%20define%20the%20logic%20for%20it%2C%20e.g.%20on%20every%20space%2C%20every%20Nth%20character%2C%20etc).%20But%20that's%20not%20exactly%20automatic%20overflow.%3C%2FP%3E%0A%3CP%3EOr%20TextBox.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
cuong
Microsoft

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 trainingSupport and more.

 

Cuong

Microsoft

12 Replies
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?
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.

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

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?
this sounds good! how do i join? I am new to excel
Looks like you've already joined the community. Welcome! Let me know if there's anything else we can help with.

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

@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.

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

@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.