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%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%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%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%20noopener%20noreferrer%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%20noopener%20noreferrer%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%20noopener%20noreferrer%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%20noopener%20noreferrer%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%3CLINGO-SUB%20id%3D%22lingo-sub-815859%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-815859%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%3BCtrl%2BShift%2B%3A%20enters%20a%20static%20time%20stamp.%20If%20you%20want%20something%20that%20will%20update%2C%20you%20can%20use%20%3DNOW()%20and%20format%20as%20desired.%20Whenever%20Excel%20calculates%2C%20the%20formula%20will%20update.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that's%20what%20you're%20after...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880938%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-880938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20evening!%3CBR%20%2F%3EThank%20you%20for%20receiving%20me%20in%20the%20press%20releases.%3CBR%20%2F%3EI%20have%20a%20problem%20and%20please%20help%20me%20if%20you%20can!%3CBR%20%2F%3EHow%20can%20I%20do%20if%20the%20percentage%20in%20A1%20is%20%3D%20100%25%20B2%20to%20be%20copied%20to%20Sheet2%3F%3CBR%20%2F%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881555%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-881555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416855%22%20target%3D%22_blank%22%3E%40Cristi1974%3C%2FA%3E%26nbsp%3BYou'll%20need%20VBA%20for%20that.%20How%20is%20the%20value%20in%20A1%20changing%3F%20If%20it's%20due%20to%20a%20formula%2C%20then%20you%20can%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.worksheet.calculate%2528even%2529%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWorksheet%20Calculate%3C%2FA%3E%20event.%20If%20it's%20due%20to%20a%20manual%20entry%2C%20then%20you%20can%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.worksheet.change%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWorksheet%20Change%3C%2FA%3E%20event.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887039%22%20slang%3D%22en-US%22%3ETrick%20for%20Scrolling%20and%20freezing%20titles%20while%20you%20scroll%20to%20new%20locations.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887039%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Sir%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20function%20for%20title%20changing%20while%20scrolling%20up%20and%20down%20on%20a%20spreadsheet%20where%20the%20title%20covers%20a%20group%20in%20view%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887108%22%20slang%3D%22en-US%22%3ERe%3A%20Trick%20for%20Scrolling%20and%20freezing%20titles%20while%20you%20scroll%20to%20new%20locations.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418255%22%20target%3D%22_blank%22%3E%40TantalumMan%3C%2FA%3E%26nbsp%3BIf%20you%20can%20format%20your%20%22groups%22%20as%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FOverview-of-Excel-tables-7AB0BB7D-3A9E-4B56-A3C9-6C94334E492C%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etables%3C%2FA%3E%2C%20then%20the%20column%20headers%20will%20convert%20to%20your%20table%20headers%20once%20you%20scroll%20past%20the%20table%20header%20row.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-888916%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-888916%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%20Excel%20bazen%20kafa%20kar%C4%B1%C5%9Ft%C4%B1r%C4%B1c%C4%B1%20olabiliyor%20sizce%20neler%20yapmal%C4%B1y%C4%B1m%20%3F%20Daha%20pratik%20hala%20nas%C4%B1l%20getirebilirim%20her%20anlamda%20.%20Te%C5%9Fekk%C3%BCrler%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-889242%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-889242%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418812%22%20target%3D%22_blank%22%3E%40jigsav%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWould%20you%20please%20share%20some%20additional%20context%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

19 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.
Highlighted

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

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

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

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

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 

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

@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 

Hi @jigsav 

 

Would you please share some additional context?

 

Thanks,

 

Cuong

Microsoft

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies