Vejledninger - Delingstips og vejledninger til Microsoft Office
Her deler vi de tip og tricks, vi kender til Microsoft Office. Det deler alle de ting, som vi lærer og oplever undervejs med at udvikle Office-tilføjelsesprogrammer og bruge Microsoft Office.
-
- Google AI Studio API-nøgle: Oprettelse, priser og begrænsninger
- Sådan beregnes Z-score i Excel: En omfattende vejledning
- Mestring af Excel-udskriftsområde: hvordan du indstiller, justerer, rydder og mere
- Fjern Excel-adgangskode fra Excel-fil/arbejdsark/arbejdsbogsstruktur
- Fjern nemt tomme celler i Excel – Fuld vejledning
- Mestring af indlejrede IF-sætninger i Excel – en trin-for-trin guide
- Excel-variansberegning: En vejledning med eksempler
- Beskrivende statistik i Excel (Hurtig og nem guide)
- Datatabel i Excel: Opret en-variable og to-variable datatabeller
- Hvad betyder & Sign i Excel-formlen? (Eksempler)
-
- Hvordan kopieres Excel-sideopsætning til andre regneark i Excel?
- Sådan fjernes første, sidste X-tegn eller bestemte positionstegn fra tekst i Excel?
- Hvordan tilføjes tekst til begyndelsen eller slutningen af alle celler i Excel?
- Hvordan udskrives intervaller i Excel?
- Excel-tip: Tæl/sum celler efter farve (baggrund, skrifttype, betinget formatering)
- Sådan anvender du en formel til en hel kolonne i Excel (5 tricks)
- Hvordan kombineres flere projektmapper i en master-projektmappe i Excel?
- Beregn alder (konverter fødselsdato til alder) hurtigt i Excel
- Hvordan udpakkes kun tekst før / efter mellemrum eller komma i Excel?
- Flet og kombiner kolonner uden at miste data i Excel
-
skyyang posted a comment in How to force text string to uppercase / lowercase / proper case in Excel?Hello, DS, To apply the code to a specified range instead of entire worksheet, please apply the following code: VBA code: Force text string to uppercase Private Sub Worksheet_Change(ByVal Target As Ra...about 3 days agocrystal posted a comment in How to automatically send email based on cell value in Excel?Hi Ernesto, The following VBA code may help. Please give it a try. Thank you. Note: If a change is detected and the new value in an "E" row cell is less than its corresponding "D" row cell, it trigge...about 3 days agocrystal posted a comment in How to send a specific chart in an email with vba in Excel?Hi Jyoti, Can you tell me what version of Excel you are using? The code works fine whether I change .Display to .Send or not.about 3 days agoMatthew Reynolds posted a comment in How to select a column based on the column header in Excel?Good job, works great!about 4 days agoMichael Lacroix posted a comment in How to insert color coded drop down list in Word table?hello . i tried but it not go.about 4 days agoTukools posted a comment in Kutools for Excel: Powerful Excel ToolboxHow do I change the location of the automatically created C:\Users\YOUR-USER-NAME\Documents\Kutools for Excel folder? Or how do I prevent Kutools from ever creating it? I keep deleting that folder...about 4 days agoOFFshacom posted a comment in How to recover the table auto-expand feature in Excel?I have applied the steps but still don't work. Someone please help me thxabout 4 days agoKAne posted a comment in How to combine date and time columns into one column in Google sheets?Work like a charm. . .. Basic always win Thanksabout 4 days agoVictor John Augustin posted a comment in How to swap or switch text around within one cell in Excel?Very good..about 5 days agoDS posted a comment in How to force text string to uppercase / lowercase / proper case in Excel?Please suggest modifications in the VBA code to force the text strings to change to the desired format (Upper/Lower/Proper case) in selected/specified cells only rather than changing the Case of the t...about 5 days ago