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

19 Replies
Highlighted
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?
Highlighted
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

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

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

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

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

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

Highlighted

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

Highlighted

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

Highlighted

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 

Highlighted

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

Highlighted

@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 

Highlighted

Hi @jigsav 

 

Would you please share some additional context?

 

Thanks,

 

Cuong

Microsoft

 

Related Conversations
IF statements and conditional formatting
clare1981 in Excel on
0 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
4 Replies