Windows 10: Excel beginner questions

Discus and support Excel beginner questions in Windows 10 Support to solve the problem; Hi I've made an Excel (In fact, Google Sheet) which is used to make a record of my cash income and expense there are three columns - "Income"... Discussion in 'Windows 10 Support' started by Tsw88, Jan 4, 2019.

  1. Tsw88 Win User

    Excel beginner questions


    Hi

    I've made an Excel (In fact, Google Sheet) which is used to make a record of my cash income and expense

    there are three columns - "Income" "Expense" as well as "Balance"
    , similar to most bank statement record.

    I am a beginner and I am able to calculate the new "Balance" from the last "Balance" and the new "Income" (Plus) or "Expense" (Minus) i.e. =sum(last Balance + Income - Expense)

    However, I want to make it more automatic, so that in the next row I can only put in either income or expense and then it will give out the new "Balance" at the last, instead of having to manually input the =sum into each Balance cell,

    But how to ?

    Do you understand my question? Thank you very much!

    :)
     
    Tsw88, Jan 4, 2019
    #1
  2. PUM
    Pum Win User

    newbie in need of help

    Well this is an excellent guide for OC beginners:
    A Beginner's Guide to Overclocking
    I suggest you read this and come back with questions to clarify anything necessary.
     
  3. OrbitzXT Win User
    Excel Drop Down Menu Question

    I'm toying around with a project for work. We're trying to make an Excel spreadsheet that has a list of parts that employees would sort of use to build an order form. It's coming along nicely and works fairly well with the touch screen tablet we have, but I had a question. At the moment, when you highlight a cell that has a drop down list of choice, a small box with a down triangle appears in the bottom right. You click that, then the list of items appears. Is there anyway I can make it so that when you click the cell the drop down menu appears? This would make working with the spreadsheet on the tablet many times easier.
     
    OrbitzXT, Jan 4, 2019
    #3
  4. Mithin_EJ Win User

    Excel beginner questions

    How can I print a Half Sheet (5.5 x 8.5 inch) paper in Excel Office 365

    Hi MarshaTravis,



    Thank you for posting your question in the Microsoft Community.



    I would suggest you to follow the below steps, to print a Half Sheet paper in Excel.



    1. Open the Excel Spreadsheet.
    2. Go to File, click on Print.
    3. Under the Print Settings, select the option "Custom Scaling".
    4. Then select the option "Custom Scaling Options".
    5. Under Page tab, select the option "Adjust to:" Change the value to 50%.
    6. Click OK, and try to print the Excel paper.


    Hope it helps,

    Let us know if you got the help you needed by clicking Yes Or No
     
    Mithin_EJ, Jan 4, 2019
    #4
Thema:

Excel beginner questions

Loading...
  1. Excel beginner questions - Similar Threads - Excel beginner questions

  2. Activate Windows for Beginners?

    in Windows 10 Updates and Activation
    Activate Windows for Beginners?: My Laptop returned from repair shop with Windows 10 PRO! It went into shop with Windows 10 HOME "up to date" and free upgrade from Windows 8.1. I now get blue banner "Activation Expire Soon...…" (settings say "Windows is activated using your organisation etc...)...
  3. Excel beginner questions

    in Microsoft Office and 365
    Excel beginner questions: Hi I've made an Excel (In fact, Google Sheet) which is used to make a record of my cash income and expense there are three columns - "Income" "Expense" as well as "Balance" , similar to most bank statement record. I am a beginner and I am able to calculate the new...
  4. beginner

    in Windows 10 Software and Apps
    beginner: while installing apps it says to restart to finish how do I do that https://answers.microsoft.com/en-us/windows/forum/apps_windows_10-winapps-appscat_tools/beginner/d4a78bfa-c5a4-475b-99c3-5ec6947fa948
  5. for beginner problems

    in Windows 10 BSOD Crashes and Debugging
    for beginner problems: how can I upload bluescreen dumpfiles with file extension names of .dmp when they are having an error ...thanks a lot guys 71566
  6. Excel Conditional formatting question.

    in Microsoft Office and 365
    Excel Conditional formatting question.: If I wanted to make a conditional formatting rule that would select all cells in a column [I2-I65] with a formula generated value less than 0.9 and greater than 1.1, ignoring all empty cells, what formula would I use? Thanks. 83089
  7. Beginner question: difference between Home and Home N

    in Windows 10 Installation and Upgrade
    Beginner question: difference between Home and Home N: Which version should I pick and why? Does N version cost more? I'm doing a completely fresh install and I'm going to buy the license after the installation. Also I don't think a need the Pro version. Home or Home N [img] 33242
  8. 4 beginner questions: Home-Pro, Recovery Drive, 32 GB eMMC, drivers

    in Windows 10 Installation and Upgrade
    4 beginner questions: Home-Pro, Recovery Drive, 32 GB eMMC, drivers: Some beginner questions about 10. Did some reading on the forums, some important questions still left. (I thought I will just wait until Threshold 2 to come out to install it) 1. Comparing Home and Pro (and Education and Enterprise): all the ISOs are the same size. I see...
  9. Windows 10 development for absolute beginners

    in Windows 10 News
    Windows 10 development for absolute beginners: The absolute beginners series is back for Windows 10. It doesn’t matter if you’re a pro dev or just starting out, there’s valuable content for everyone. If you’re looking for a faster pace content that dives deep, the Developer’s Guide to Windows 10 series may be for you. The...
  10. OneDrive Beginner Questions

    in Windows 10 Support
    OneDrive Beginner Questions: Hi There, I'm finding all of the information a bit confusing re the use of OneDrive. I have started to use OneDrive with 1TB capacity as an off site back up of my files, the Outlook ones being quite large, the rest not so much. I have several local daily/weekly backups. I...