How To Add Slope In Excel Mac

Plotting A Best Fit Line. There are three steps to create an add-in and make it available in the QAT. I plotted a scatter plot for these 2 sets. When Excel displays the Data Analysis dialog box, select the Regression tool from the Analysis Tools list and then click OK. This is true of Goal Seek. I assume that you have already displayed the equation of the Trend line on your chart as suggested by Josh Burdett. Excel add-in screenshots and features. Know that this is just a specific symbol used often. Open Excel for Mac 2016. Add a linear trendline, and on the Options tab, select Display. How to Put Two Graphs Together in Excel on a Mac. com! My name is Mike Rempel and I am certified as a Microsoft Excel 2010 Specialist. Excel 2007-2016 version 1. How to Password Protect a Folder in a Mac. Being able to customize the Excel toolbar on a Mac is a little different than on a PC, but Microsoft has made great strides in making the applications more consistent, robust, and easier to configure for both platforms. Open an Excel spread sheet. Melanie Pinola. Good Luck!!! How to Recover Excel XLB File on Windows or Mac?. Help Microsoft with Feedback As part of the Pre-release Program, Microsoft would love to get your feedback on how to make pivot charts better. Excel Barcode Add-In Video Tutorial. Being able to customize the Excel toolbar on a Mac is a little different than on a PC, but Microsoft has made great strides in making the applications more consistent, robust, and easier to configure for both platforms. Right-click on the highlighted cells and select Format Cells Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells. External data in Excel 2016 for Mac. If you use Microsoft Office for Mac: Excel, then you need to add multiple lines of the information into a cell. The functions are SLOPE(), INTERCEPT(), CORREL() and RSQ(), and are also covered in the statistics section of this tutorial. 180124 is available as a free download on our software library. This equation will include the slope. Though a great tool for performing simple statistical calculations, Microsoft Excel does not automatically provide a way of finding these beta coefficients. To perform regression analysis by using the Data Analysis add-in, do the following: Tell Excel that you want to join the big leagues by clicking the Data Analysis command button on the Data tab. Firstly, we will acquire excel graph with very little data values. Open an Excel spread sheet. In this course, learn how to master the essential tasks in the Mac version of Excel for Office 365. This illustrated tutorial shows how to freeze cells in Excel. Add a comment. Toggle navigation. what software do i use to in Mac to be able to use the word and excel. Rather than copy and paste, Acrobat X exports to an Excel workbook from where you can transfer into an existing table if required. Remember that the slope of a line never changes, so you can choose whatever 2 points you want and you will always get the same slope. Downgrade to 7 and next time a Mac i guess. The SLOPE function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac. Another area you can customize is the Quick Access Toolbar. The Analysis ToolPak is an add-on in Microsoft Excel. Slopes of linear functions. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. xla are the extensions this PC software can process. In Windows Excel I have used the Data Analysis Tool to do multiple regressions, but that is not available in Excel 2011 for the MAC. It can be created by entering a list of values corresponding to any set of measurable items. To perform regression analysis by using the Data Analysis add-in, do the following: Tell Excel that you want to join the big leagues by clicking the Data Analysis command button on the Data tab. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. 222 Excel shortcuts for Windows and Mac | Exceljet. In this tutorial we will extrapolate Excel graph to find predicted values. Choose to save it as a. Release the keys. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. Learn the basics of SLOPE to understand the working method of SLOPE in excel. In the screen that pops up, at the top you will either see 32-bit or 64-bit. For example, in the. If you’re really new to using Excel you should take a few minutes to learn the basics before getting started. Outlook for Mac differs from the Windows Outlook version in that it does not have an option to export to a CSV file. To do so, employ the spreadsheet program Microsoft Excel. Excel Tips Tutorial: How to Display Text at a 45 Degree Angle (Diagonal Text) Many Excel users like to display the content within their column headers at an angle or diagonally across the cell. If you use Microsoft Office for Mac: Excel, then you need to add multiple lines of the information into a cell. – MAC users • 1. How to Edit PDF on Mac If you want to edit PDF text on Mac as easily as on a Word document, you need a powerful PDF editor like PDFelement Pro PDFelement Pro. I have recently bought a Mac book pro. LINEST returns a value of 0. We also boast an active community focused on purchasing decisions and technical aspects of the iPhone, iPod, iPad, and Mac platforms. Welcome to our Excel for Mac 2016 review, updated on 29 February 2016. If you've got data, but aren't sure how to put it in that linear form, Excel for the Mac can help. To add this button, select the Button icon from the Tool menu. Add Groupon deal to cart by clicking the big green "BUY!" button. To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. In Excel, you could fit a trendline. SLOPE Function Description: The SLOPE Function Calculates the slope of a line generated by linear regression. Mac game downloads including free mac games demos, shareware, updaters, add-ons, movies, and more. 1) Open the workbook you want to protect. Comes with a 230-page user guide (available available online); works with English language versions of Excel for Windows. Add a linear trendline, and on the Options tab, select Display. Open Microsoft Excel. Adding New Lines to Cells in Excel for the Mac I was going crazy not knowing how to do this so-very-often required feature of adding new lines to an excel cell on. PowerPivot is made up of the Excel free add-in and the SharePoint server component. Note: version 1. But when you desperately want to add a line break—and Enter simply isn't working—it's good to know that you can. - Davis This January 2009 help sheet gives information on Fitting a regression line using Excel functions INTERCEPT, SLOPE, RSQ, STEYX and FORECAST. Calculating the slope of a line is extremely simple. Power Query is not yet available for the Mac versions of Excel. In this article, we'll show how to install PHP 5 as an Apache 2. Right click the column header and then click insert in the drop down box - this will add a column to the left of the column you selected. Feb 05, 2016 · If you truly need Publisher the you have the following options: Open obtain. Welcome to our Excel for Mac 2016 review, updated on 29 February 2016. To do so, employ the spreadsheet program Microsoft Excel. After your Mac validates the font and opens the Font Book app, the font is installed and available for use. None of these solutions work for me, and the "best" solution is not a good solution at all as it only works with Excel, and no product that generates a csv will add that line to the front. Add-ins are different extensions of excel which when enabled they activate when the excel is started and a user can use its functions, excel has various different add-ins and they are in the options section of the file tab, the first box shows the enabled add-ins in the system and if the user wants to enable more add-ins we need to click on manage add-ins. How do I get more sig figs in Excel for the trendline equation? I am using Excel:mac 08, but if you know how do to this in any version, it will help. How to add a vertical line to the chart. You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and applications as well. In this post, we'll quickly cover how to enable the Developer Tab for both Windows and Mac. xla add-in file that you downloaded above. I paid a full Microsoft Office subscription with Excel ( £119 Sterling for the 2019 version ) as I needed to use PowerQuery and PowerPivot, however I was completely un-aware these Tools were not supported on Mac yet !. Excel 2016 for Mac brings lots of welcome improvements to the workhorse spreadsheet but also leaves out useful tools. If you're looking to export just a single graph or chart and not an entire worksheet to PDF here's how to do just that. For changing decimal places i. How do i find the equation of the line and R2? I don't have Excel 2008 handy to test, but usually one way is to right-click (or Control-click) the trendline, choose Format Trendline from the pop-up menu, click Options, click "Display equation on. If you are running Excel on a Mac, you will need to save the file as a Windows Comma Separated (. Once you enter your data into an Excel spreadsheet, the program can produce a scatter plot graph, which is a useful tool for visualizing your numbers. You can add drop-down lists to cells in Excel containing options such as Yes and No, Male and Female, or any other custom list of options. At this point excel will select only one data label. I'm looking for a shortcut to add a row above the current cell in Microsoft Excel 2016. Note that even though the screenshots below are from an older version of Word, the same procedure will work on all versions of Word, including Word 2016, 2013, 2010, etc. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. “Free” add-in for Excel 2010 and 2013 for Windows. When the slope is equal to zero, we say that there is no slope A positive slope:. Microsoft Excel has an inbuilt Lotus-to-Excel converter which can save a WK4 file in XLS format. With negative slope the line moves down when going from left to right. The column always comes before the row, or, letter before number. Welcome to Excel-bytes. Excel Barcode Add-In Video Tutorial. How to Create a Trendline in Excel for Mac CRProductions. Remove fonts. In this tutorial, you'll learn how to create an Excel add-in. com: CZUR ET16 Plus Book & Document Scanner with Smart OCR for Mac and Windows, Patented Laser Auto-Flatten & Deskew Technology, Convert to PDF/Searchable PDF/Word/Tiff/Excel: Office Products. 7) or Mountain Lion (10. ” Step 3: Next, click the “Protect Workbook” button. If a project created on one platform (Mac or Windows) is opened on the other platform, images added under the original platform do not display any longer. Press the power button. Excel Tips Tutorial: How to Display Text at a 45 Degree Angle (Diagonal Text) Many Excel users like to display the content within their column headers at an angle or diagonally across the cell. Also, when Excel 2010 was released, two of the existing standard deviation functions were updated and renamed. If you don’t have broadband access, you can upgrade your Mac at any Apple Store. This page describes how to write your own worksheet functions in VBA. Figure out the beta coefficient by using the 'SLOPE' function in Excel. However, in math, slope is defined from left to right. How to Create a Graph Using a Spreadsheet. You can use the menus at the top, the mouse context-menu or the reviewing toolbar. From the drop-down menu, then select “Encrypt with Password. Scan to Excel OCR Converter is a useful tool application to convert scanned image to Excel document with the best OCR technology in the market. See the image below for more info. Excel Barcode Add-In Video Tutorial. Creating a single line graph in Excel is a straightforward process. Allow it to install if. 629*100 = 3% and the uncertainty in the intercept is 12%, which is only about two significant figures in each. If you open the. Some tips and macros for snaking columns for smaller reports and to save paper. Do the same for the range A11:B14. The INTERCEPT and SLOPE algorithm is designed to look for one and only one answer, and in this case there can be more than one answer. Now I need to support these add-ins on MAC OS. Admittedly, Excel 2016 for the Mac is better. In this tutorial we will extrapolate Excel graph to find predicted values. Installation instructions for the Windows versions of Excel can be found here. Inserting a Scatter Diagram into Excel Suppose you have two columns of data in Excel and you want to insert a scatter plot to examine the relationship between the two variables. How to Add a Link in Excel for Mac 2011. SLOPE in Excel VBA. Last time that happend to me i still had all my hair. bas file, into my workbook. When the slope is equal to zero, we say that there is no slope A positive slope:. Plot and label 2 points on the line, anywhere on the line. Suppose we have the X's values located in the excel sheet range from A1 to A10, and Y's values located in the given excel sheet from range B1 to B10, then we can calculate the SLOPE here by using the below VBA functions. You can also convert documents without leaving the application using the Acrobat task ribbon in Office for Windows or the Print command in Windows or Mac OS. In Excel, you could fit a trendline. Likewise you can export an Excel sheet to PDF. I've got two columns of data and I want a single line -- I want one column to be the X axis, and the other to be the Y axis. Excel has the ability to create a trendline automatically, or you can manually draw the tangential line on the graph. To get around this, you need to install the "Analysis ToolPak" add-in (available in Excel) and perform a linear regression on your data. Then we will select the information and use the insert option to make a graph in excel. Creating an Excel Add-in. For Mac 2016 you need to install the solver add-in and analysis tool pak. Anyone that knows a fix or work around other then reverting back to 2011 version of excel?. All of the data points should now be highlighted. The slope of the tangent line reveals how steep the graph is rising or falling at that point. Before you edit: Gridlines can be added to line, area, column, bar, scatter, waterfall, histogram, radar, or candlestick charts. This is very important! There are three types of slope you can encounter. Tags: Addition And Subtraction Formulas How do You Subtract How do You Subtract in Excel How to Add And Subtract in Excel How to do A Subtraction Formula in Excel How to do Subtraction in Excel How to Subtract How to Subtract Cells in Excel How to Subtract Columns in Excel How to Subtract in Excel How to Subtract Multiple Cells From One Cell in. I plotted a scatter plot for these 2 sets. To do so, select the range A2:B8 and choose Insert, Name, Create. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. The Microsoft Excel SLOPE function returns the slope of a regression line based on the data points identified by known_y_values and known_x_values. when i insert a new pivot table, and point to an Access database, MS Query for Mac opens. How to make a trendline in Excel 2010. Here we discuss the SLOPE Formula in Excel and how to use SLOPE Function in Excel along with practical examples and downloadable excel templates. You’ll have Office applications on your Mac or PC, apps on tablets and smartphones for when you're on the go, and Office Online on the web for everywhere in between. That will add the equation that Google Sheets used to calculate the trendline, and the slope of our line is the part to the left of the "*x" term. The Analysis ToolPak is an add-on in Microsoft Excel. Excel only allows you to change one variable. This Excel Tutorial demonstrates how to use the Excel SLOPE Function in Excel to calculate the slope, with formula examples. How to add slope formula to graph [SOLVED]. For example, if your data points are recorded in cells A1 through A20, you would type =stdev(A1:A20) in an empty cell to get the Standard Deviation. So here is your perceptual map – you can add a heading on the map (in the same way that we did the axis labels) or you can add a heading in your marketing report. Adding drop lines and high-low lines to charts in Excel 2011 for Mac. Excel for Mac — 2011 or 2008 — doesn't have a Quick Access Toolbar, but you can customize the toolbars and menus. If you want to insert a new specific worksheet to your workbook with a nice layout and maybe a few formulas on a regular basis then you have two options. For Excel 2004 Mac. bas file, into my workbook. “Free” add-in for Excel 2010 and 2013 for Windows. The first option is to create a map in Microsoft Excel, then create a slide from Excel. You are probably visiting this page because you were referred to it by someone in a newsgroup. 2) On the Review tab, under Protection, click Passwords. But when you desperately want to add a line break—and Enter simply isn't working—it's good to know that you can. You simply add a number, such as 1, and then look to see what happens to the graph. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. If you’re running Lion (10. I'm still getting the "This action won't work on multiple selections" when trying to add a new sheet in Mac Excel 16. The slope of that line is equal to the spring constant k. Migration Assistant copies all of your files to your new Mac so that you don't have to copy your files manually. But that doesn’t mean it’s not one of the best. Welcome to Excel-bytes. Formulas offer a quick way to find the sum of a few digits. CSV (Comma Separated) file. How to uninstall an Add-in (Mac) If you wish to uninstall an Add-in completely, delete, move or. bas file, into my workbook. Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you don't see the Solver Task Pane in your worksheet, you need to insert the Solver add-in: Follow the steps in Microsoft Office Support on How to get an Office Add-in for Excel. Why is this? In the Mac App Store release of Persona, the list of Heroes does not appear in the Source List in Learn Mode. Adding drop lines and high-low lines to charts in Excel 2011 for Mac Two special kinds of lines can be added to your line chart: drop-lines and high-low lines. Protect an Excel Workbook with activation, a secure Trial, Product or Subscription license and customized user experience. Let's say we have the data set below, and we want to quickly determine the slope and y-intercept of a best-fit line through it. Some similar macros to rearrange columns / rows to prepare data for address labels from various sources including some with database tags. 3 File date(1 April-2010). Solver and Data Analysis Add-ins for Excel for Mac 2016 Install Solver Add-in for Excel for Mac 2016. The slope of the tangent line reveals how steep the graph is rising or falling at that point. It can be created by entering a list of values corresponding to any set of measurable items. Click “Add-Ins”, and then in the Add-Ins box, check “Solver. There is a lot to learn about Microsoft Excel, and not everything is in the manual. Excel in Numbers you can view Excel files on your Mac. Excel VBA Course (Beginner To Advanced) If you want to be a master at Excel VBA Programming language for Excel 2007, then our Excel VBA macros tutorials will make it easier for you to access it in applications such as Microsoft Office. Scan to Excel OCR Converter is a useful tool application to convert scanned image to Excel document with the best OCR technology in the market. Help Microsoft with Feedback As part of the Pre-release Program, Microsoft would love to get your feedback on how to make pivot charts better. Here's how to quickly create a drop-down list in Excel on Mac. Sign in to add this video to a playlist. Lets take a look at how to increase/decrease the decimal places. One of the most common and convenient forms of a linear equation is y = m*x +b,. This Excel Tutorial demonstrates how to use the Excel SLOPE Function in Excel to calculate the slope, with formula examples. Write/Record the Code in a Module. however, nothing to stop you 'cheating' and adding the same data series to the chart twice. If you recently picked up one of these devices for the first time, you might be a little confused on how to enter DFU mode when your iPhone acts up. (Note: Password to modify, does not encrypt the document). The uncertainties in the slope and intercept are not as good as the r2 of 0. From left to right, the first row displays the slope and y-intercept, the second row displays the. To add a layer of protection, you need to know how to password protect an Excel file. From the status bar at the bottom to the ribbon at the top, you can remove and add exactly what you need. To add/enable developer tab in excel 2007, 2010, 2013, 2016 & excel 2011 For Mac. When you click on the Line Chart type a chart representing the selected data will appear. How to Install Analysis ToolPak in Excel For Mac and Windows. Help Microsoft with Feedback As part of the Pre-release Program, Microsoft would love to get your feedback on how to make pivot charts better. 5 will include VST plugin support. Firstly, we will acquire excel graph with very little data values. This is a tutorial which shows how to calculate averages and standard deviation for rows of data, then generate a line graph with standard deviation in the e. Though a great tool for performing simple statistical calculations, Microsoft Excel does not automatically provide a way of finding these beta coefficients. The SLOPE function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function. How to Put Two Graphs Together in Excel on a Mac. Now the problem is how to select the second series to add trendline. I plotted a scatter plot for these 2 sets. Download and install the Barcode Add-in for Word and Excel to activate the toolbar. In order to do this version of the linear regression analysis, using Excel, you have to begin by creating a data table that has the independent and dependent variables. Learn how to convert & open. In this application, two output formats are supported, including MS Excel 97-2003 and MS Excel 2007 formats. Slope shows both steepness and direction. The SLOPE function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function. For formulas to show results, select them, press F2, and then press Enter. How to add a vertical line to the chart. Generally you can add all form control elements like button, scroll bar, combo box, list box, etc. If you use the same Microsoft account to buy or redeem multiple Office 365 subscriptions, you extend the amount of time for your subscription, up to a maximum of 5 years. Disk Utility offers one easy trick that turns folders into vaults. Excel has features that allow you to plot the data pairs graphically in a chart, add a trendline (calibration curve), and display the calibration curve’s equation on the chart. [1] Actually, I perceive a horizontal slope from 10/10 thru 10/22, and a downward slope from 10/20 thru 10/27. Release the keys. However, if you are working with a cell that you want to have more than one line of text, it can be frustrating to create a new line. Because of the nature of such problems, it is important to provide feedback when you solve your problem by replying back to the thread so that others can be helped and so that pages such as this can show relevant information. In Microsoft Excel. EXCEL 2007: Two-Variable Regression using function LINEST A. I have recently bought a Mac book pro. an integrated approach for reducing uncertainty in the estimation of formation water saturation and free water level in tight gas reservoirs – case studies. A ready-for-Retina. We've set up the data tables and Excel charts for you, so you enter the Dates and event descriptions and adjust the heights of the lines to get things to fit the way you want. Enable Speak Cells in Excel. How to Add Secondary Axis in Excel. To save a specific table from a PDF document, draw a selection box around it, right-click the selection and choose Export Selection As, then choose Excel Workbook from the file type menu. I used to hold ctrl and select columns in Windows. From the status bar at the bottom to the ribbon at the top, you can remove and add exactly what you need. Calculating the slope of a line is extremely simple. Is there a way I can smooth the chart - either as a chart featu. I want to transfer all my data( mostly word, excel and photos) to my Mac. Come for help, be inspired. 4 L/mol then right click on the same data point and the option to "add. Know that this is just a specific symbol used often. After all, Excel already has a great system for organizing and separating data: all of those thousands and thousands of tiny cells in your worksheet! The more you rely on cells for organization, the better Excel will work for you. How to Calculate Slope in Excel. The Developer Tab is where you'll find tools that you can use to record macros, access the Visual Basic Editor, add add-ins, and more. However, in math, slope is defined from left to right. slope = change in y/change in x = rise/run. 1) Using the Tools menu version of the regression analysis to obtain the results of the analysis in a table. Automatic install wizards dumping icons all over my desktop without asking or my word processor auto correcting things it thinks are wrong. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. The baseline for serialization of dates in Microsoft Excel starts from "01 Jan 1900" which is assigned a serial number of 1 in Microsoft Excel program. So six two over one is equal to six over three is equal to two, this is equal to the slope of this magenta line. Adding a button to reset a form can be an efficient way to clear data from the form. Click “Add-Ins”, and then in the Add-Ins box, check “Solver. This works in most cases, where the issue is originated due to a system corruption. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. The easiest way to split text is usually with a spreadsheet—and in Microsoft Excel on your Mac or Windows desktop, it only takes a few clicks. This Excel tutorial explains how to use the Excel SLOPE function with syntax and examples. In this case, the slope is +1251; for every month that passes, the trend is for the sales revenue to increase by $1251. Comes with a 230-page user guide (available available online); works with English language versions of Excel for Windows. You’ll have Office applications on your Mac or PC, apps on tablets and smartphones for when you're on the go, and Office Online on the web for everywhere in between. The tangent line for a graph at a given point is the best straight-line approximation for the graph at that spot. Learn more about how to upgrade to macOS Catalina. Windows 10 did it – i am unable to add a printer. And I also assume that you want to see more digits in those coefficients. It has been built to help people manage Instagram at scale, and is constantly adding more features to make the process even easier. Step 1 - Open excel, type x in cell A1 and type y in cell B1. As the article suggests, today we will learn how to add Analysis ToolPak in Excel For Mac and Windows PCs. 4 Replies seeprime; Beats launches the Solo Pro headphones with. SLOPE Function Description: The SLOPE Function Calculates the slope of a line generated by linear regression. Your user library folder will open. Want to make a FOR LOOP in Excel using Formulas? In this article, I've shown how you can make one using Excel functions: OFFSET(), MAX() and MIN(). Step # 1 – The graph. Type some unsubscribe instructions in your email and highlight the text that you would like to use as your unsubscribe link. If you want to insert new line in Excel for Mac,. My classmates who are using Word are getting the correct answer. So let's get started. Is there a way I can smooth the chart - either as a chart featu. Please help. After your Mac validates the font and opens the Font Book app, the font is installed and available for use. Slope of the linear regression line through the data points in A3:A9 and B3:B9. Know that this is just a specific symbol used often. What is amazing. hey – i am using windows now for more than 20 years. Find expert advice along with How To videos and articles, including instructions on how to make, cook, grow, or do almost anything. Also, when Excel 2010 was released, two of the existing standard deviation functions were updated and renamed. To add/enable developer tab in excel 2007, 2010, 2013, 2016 & excel 2011 For Mac. Hold the keys until your Mac restarts. Fonts that are disabled show ”Off” next to the font name in Font Book. Adding a Trendline in Line or Column Chart. Use the arrow keys to more thru chart items, watch the name box to see what has been selected best wishes. Open Excel. Hi Everyone, I'm having difficulty adding a specific slope of -0. 4 L/mol then right click on the same data point and the option to "add. Select a column or row of data cells, choose "CODE 128", and then click "Generate". However, the old functions are still available in current versions of Excel, in order to maintain compatibility with older versions. XLSTAT is a powerful yet flexible Excel data analysis add-on that allows users to analyze, customize and share results within Microsoft Excel. I've owned my very first IMac for two days now and I follow all the instructions I read on how to protect certain cells in one of our Excel spreadsheets (we easily did this when using Microsoft Excel on a PC) but the MAC version of Excel seems to only let you protect the whole sheet or nothing, there is not an option to just protect some of the cells. You can even create custom macros and commands and add them to the Quick Access Toolbar or Ribbon Toolbar if you like. The slope of that line is equal to the spring constant k. Welcome to Excel-bytes. So I've got some data, which has the approximate form of a sine function. If you use Office:Mac Excel, you may from time to time need to capture multiple lines of information into a cell. How do i find the equation of the line and R2? I don't have Excel 2008 handy to test, but usually one way is to right-click (or Control-click) the trendline, choose Format Trendline from the pop-up menu, click Options, click "Display equation on. Enjoy! Read More. Select the cells that need to be changed into a.